Question: can you please do question 4,5,6? Using the Ch07_SaleCo database (ER Diagram attached), use SQL queries to answer the following questions. For each question, show

can you please do question 4,5,6? Using the

can you please do question 4,5,6?

Using the Ch07_SaleCo database (ER Diagram attached), use SQL queries to answer the following questions. For each question, show the query and some evidence (screen shot, copy of the output) of your query's success. 1. For all customers with non-zero balances in the 615 area code, list the full customer name. 2. For products with fewer than 15 items in stock (P_QOH), list the product description and price. Relabel the report columns with more understandable headings. 3. Assuming that the discount column in the product table is available to preferred customers, report the discounted price of products for all products with a before discount price of more than $100. 4. Customer Anne Farriss has called, asking for a listing of her invoice numbers and dates. 5. Corporate Management would like a list of all products sold by companies located in Florida. 6. Customer Anne Farriss called back and would like a complete account. This listing will need her name, phone number and balance, and invoice information

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 General Management Questions!