Question: Given the schema and table above, Execute SQL statements to answer the following questions: a. Who are the customers who have placed 0 orders? b.

Given the schema and table above, Execute SQL statements to answer the following questions:
a. Who are the customers who have placed 0 orders?
b. Who are the customers who have placed between 1 and 3 orders?
c. Who are the customers who have placed 4 or more orders?
E ...EEE CUSTOMERS CUSTOMER ID CUSTOMER FIRST NAME CUSTOMER LAST NAME CUSTOMER ADDRESS CUSTOMER CITY CUSTOMER STATE CUSTOMER ZIP CUSTOMER PHONE CUSTOMER FAX CUSTOMER STATUS ID EEE GENERAL LEDGER ACCOUNTS INVOICE LINE ITEMS INVOICES ITEMS E E ORDER DETAILS ORDER ID ITEM ID EEE ORDER QTY E ...EEE ORDERS ORDER-ID CUSTOMER ID ORDER DATE SHIPPED DATE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
