Find the ID, first name, and last name of each customer that currently has an invoice on
Question:
Find the ID, first name, and last name of each customer that currently has an invoice on file for Wild Bird Food (25 lb).
List the invoice number and invoice date for each invoice created for the customer James Gonzalez.
List the item ID, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category CAT. Use either the ALL or ANY operator in your query. (Hint: Make sure you select the correct operator.)
For each item, list the item ID, description, units on hand, invoice number, and quantity ordered. All items should be included in the results. For those items that are currently not on an invoice, the invoice number and quantity ordered should be left blank. Order the results by item ID.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last