The Customer$\_$Order table, which stores data about customer orders, contains the folowing data:

Customer$\_$Order

Prompt $2$ Questions

$($There are $8$ questions for Prompt $2).$

Write a query to retrieve each unique customer ID $($cust$\_$id$)$ from the Customer$\_$Order table.

There are

multiple ways to construct the query, but do not use a subquery.

Write a query to retrieve each unique customer ID $($cust$\_$id$)$ along with the latest order date for each

customer. Do not use a subquery.

Write a query to retrieve all rows and columns from the Customer$\_$Order table, with the results sorted by

order date descending $[$latest date first$)$ and then by customer ID ascending.

Write a query to retrieve each unique customer $($cust$\_$idi$)$ whose lowest order number $($order$\_$num$)$ is at least

Please note that this is referring to the value of the lowest order number and NOT the order count. Do

not use a subquery.

Write a query to retrieve only those customers who had $2$ or more orders on the same day. Retrieve the

cust$\_$id and order$\_$date values, along with the tatal number of orders on that date. Do not use a subquery.

Along with the Customer$\_$Order table, there is another Customer table below. Write a query that returns the

name of each customer who has placed exactly $3$ orders. Do not return the same customer rame more than

once, and use a correlated subquery $($no JOINS please$)$ against Customer$\_$Order to determine the total

number of orders for each customer:

Customer

cust$\_$id cust$\_$name

$121$ Acme Wholesalers

$234$ Griffin Electric

$336$ East Coast Marine Supplies

$544$ Sanford Automative

Construct a different query to return the same data as the previous question $[$name of each customer who

has placed exactly $3$ orders$)$ but use a non$-$correlated subquery $($no JOINS please$)$ against the

Customer$\_$Order table. It is important to code a non$-$correlated subquery for this question.

Write a query to retum the name of each customer, along with the total number of orders for each customer.

Include all customers, regardless if they have orders or not. Use a scalar, correlated subquery $($no JOINS

please$)$ to generate the number of orders.