Question: Need help on #2 ITSS 4300 - Lab 4 Using the script file provided, write and execute the following queries. Write the query in this

Need help on #2Need help on #2 ITSS 4300 - Lab 4 Using the scriptfile provided, write and execute the following queries. Write the query inthis document and provide a screen shot of the results 1. Provide

ITSS 4300 - Lab 4 Using the script file provided, write and execute the following queries. Write the query in this document and provide a screen shot of the results 1. Provide a list of customers who have not purchased an invoice. Display the customer code, their last name and their first name. Sort by cuscode in ascending order CUS_CODE CUS_LNAME CUS FNAME 10013 lowski Paul 1e017 Williams George 1ee1e 10016 10019 Ramas Brown Smith Alfred James olette Download CSV 5 rows selected SELECT CUS_CODE, CUS_LNAME, CUS_FNAME FROM CUSTOMER WHERE CUS_CODE NOT IN (SELECT CUS_CODE FROM INVOICE WHERE CUs_CODE IS NOT NULL) ORDER BY CUS_CODE ASC CUS_CODE CUS_LNAME CUS FNAME 10010 Ramas 10013 Olowski Paul 10016 1e017Williams George 18019 Smith Alfred Brown ames olette 2. What is the average price of all invoices? Round to 2 decimal places. Add a column alias for the column 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!