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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!