List the customer first name and last name and the number of orders (name the column NumberOfOrders). List all customers even if they have never placed an order. Order the output by number of orders.

What are the dollar amounts of each Sale (sum the Quantity * SalePrice for each sale) made on Jan 1, 2015 for each customer? Include CustomerID, SaleID. and a newly calucalted column named SumSaleAmt.

What are the dollar amounts of each Sale (add all SaleItem amounts) for each customer? Include CustomerID, SaleID, but only inlude sales larger than $600. Name the column TotalAmt

WRITE THESE QUERIES IN SQL