Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 #2
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 nameStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started