Answered step by step
Verified Expert Solution
Link Copied!

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 #2image text in transcribedimage text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

3rd Edition

0760049041, 978-0760049044

More Books

Students also viewed these Databases questions