SQL QUERIES FROM WIDEWORLD IMPORTERS?

Create a list of Orders (with OrderID, CustomerID and OrderDate) ordered by order date with the newest date being first

Create a list of Orders (with CustomerID, CustomerName, Delivery Address 1, Delivery Address 2, Postal Code) that have a delivery postal code of 90204

Create a list of Orders with the following columns (Customer Purchase Order #, Salesperson Person ID, Customers credit limit)

Create an exception report query that lists all customers that dont have any orders

Create a list of orders (with OrderID, OrderDate, Customer ID, Customer Name) that were purchased as part of a buying group

List the customers (NO DUPLICATES..NO USING DISTINCT) who purchased on 12/31/15

Count the number of items purchased on 11/26/14. Return 1 row which also includes the date.

By unique order date (each order date gets one row) list the count of items purchased after 1/1/15 and before 1/1/16 that had a count greater than 100

List the customers whos credit limit is one of the following: $3000, $2940, $2000

List the customers whos name contains the word toys.