SQL:

1) Display all the fields from the Order Details table for the following order numbers: 10248, 10251, 10258, 10266 or 10371. Order the list by unit price in descending order.

2) List the supplier id, company name, contact name and contact title for those suppliers who are from the United States or Japan and who do NOT have a fax number. Use the Suppliers table

3) List the customer ID, order date, ship date and the number of days it took to ship the product after the order was made. This will be a calculated field and YOU MUST USE the DateDiff function. The alias name for the calculated field should be Days to Process Order. This query should include orders that meet the following criteria: the order date must have been made within the first 15 days of April in 2017. The Days to Process the Order should be between 1 and 10 days. Use the Orders table.

4) Display all of the fields from the OrderDetails table along with the following calculated field (UnitPrice * Quantity) * (1 - Discount) AS ProductSale. Only display records that meet the following criteria: the quantity ordered is within the range of 20 to 40 and the product sale was $500 to $2,000. Sort by product sale from greatest to least.