Question: Write SQL statements to answer each of the following questions. 1. List the Customer Code, Last name, and First Name for all customers, sorted by
Write SQL statements to answer each of the following questions.
1. List the Customer Code, Last name, and First Name for all customers, sorted by Last name.
2. List the invoice number and invoice date for all invoices of customer number 10014.
3. List the product code and product quantity for products in invoice number 1001.
4. List all product description and product price supplied by vendor whose vendor contact name is DuckQuack.
5. Produce a list of product description, vendor name, and vendor phone for all products with quantity less than or equal to 60.
6. For each product bought by a customer, list product description and customers first name and last name.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
