1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
koban [17]
3 years ago
10

List the invoice number and invoice date for each invoice that was created for James Gonzalez but that does not contain an invoi

ce line for Wild Bird Food (25lb).
Computers and Technology
1 answer:
Ludmilka [50]3 years ago
6 0

Answer:

Derive FROM invoice_transaction, invoice_details, item_details

and JOIN customer_details  ON (invoice_transaction.CUST_ID = customer_details.CUST_ID  AND customer_details.FIRST_NAME = 'James'   AND customer_details.LAST_NAME  = 'Gonzalez')

Explanation:

The following details will be there in the invoice

  1. item_details
  2. rep_details
  3. invoice_details
  4. customer_details
  5. invoice_transaction

 Derive FROM invoice_transaction, invoice_details, item_details

and JOIN customer_details  ON (invoice_transaction.CUST_ID = customer_details.CUST_ID  AND customer_details.FIRST_NAME = 'James'   AND customer_details.LAST_NAME  = 'Gonzalez')

You might be interested in
Mention 5 advantages of internet​
alexira [117]

Answer:

1) We can get various types of information, knowledge.

2) We can communicate with each other no matter where they are if they have internet connection.

3) It can be used as a source of entertainment.

4) Through internet, we can work from home especially in this quarantine time.

5) Through internet, we can show our talent and skills.

Hope it helps :)

If you liked it, please mark this answer as the brainliest one.

4 0
3 years ago
The records in a database table are generally visualized as​ ________.
vekshin1
The records in a database table are generally visualized as rows

Rows should be the answer 
5 0
3 years ago
You are comparing two properties for lease. The first, A, is all-inclusive at $4,000 per month. The second, B, is $2,300 per mon
Lemur [1.5K]
Take 4,000 times 12 to get 48,000. that’s how much A costs.

B is a little harder. you have to take (2,300+300)x12+(4*250). this equals $32,100

the correct answer would be B.
6 0
3 years ago
What is a collection of programs rather than a single program
zhenek [66]

Answer:

A microcomputer that is smaller, lighter and less powerful than a notebook that has a touch sensitive screen is called a: tablet. Which of the following is a collection of programs rather than a single program? system software.

4 0
2 years ago
Which of these words could byte pair encoding compress the most?
nlexa [21]

Answer:

My dad

Explanation:

7 0
3 years ago
Other questions:
  • Lisa granted the CREATE TABLE privilege WITH ADMIN OPTION to Sharon. Sharon granted the privilege to Bob. If Lisa’s privileges a
    13·1 answer
  • Complete the following method named replaceEvens that receives the parameter numbers which is an array of integers. The method m
    5·1 answer
  • Levi wants to run 5 commands sequentially, but does not want to create a shell script. He knows that each command is going to ta
    11·1 answer
  • . The first step in devising security services and mechanisms is to develop a security policy True False
    11·1 answer
  • A forensic investigator at a crime lab is performing a forensic analysis of a hard drive that was brought in by state troopers.
    10·1 answer
  • "The goal of this assignment is to give you some experience building a program that uses objects. You will use the BankAccount c
    8·1 answer
  • A derived class is a class that inherits data members and functions from a ____ class.
    6·1 answer
  • Why might you want to save a downloaded file to your computer first instead of running it immediately?
    6·1 answer
  • For a parking application that lets you pay for parking via your phone, which of these is an example of a functional requirement
    8·1 answer
  • What is the best resource to learn python?
    14·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!