Write SQL statements to answer each of the following questions. 1. List the Cust

ID: 3880513 • Letter: W

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 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 customer’s first name and last name.

1. Select Customer Code, Last name, First Name from Customers order by last name asc.

2. select invoice number, invoice date from invoices where customer number = 10014.

3. select product code, product quantity from products iwhere invoice number =1001.

4. select product description, product price from vendor where vendor contact name = 'DuckQuack'.

5. select product description, vendor name, vendor phone products where quantity <= 60.

6. select product description, first name , last name from products j.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.