Show the order id, order date, customer name, and country for all orders. (need both Orders and Customers tables)

Show the order id, order date, customer name, and country for orders with customers in Germany, Poland and Denmark. Sort by Links to an external site.order date from newest to oldest. (need Orders and Customers) [can use multiple OR conditions Links to an external site.or the IN clause Links to an external site.]

Show the product id, product name, price and category name for all products. (need Products and Categories)

Show the product id, product name, price and category name for products with the category of Beverages, Produce, or Condiments. (need Products and Categories)

Show the product id, product name, price and category name for products with both the category of Beverages or Condiments and a price between 15 and 30 Links to an external site.. (need Products and Categories)

Show the product names and supplier names for all products measured in bottles or cans (Products.Unit). Sort by supplier name. (need Products and Suppliers) Note that 'unit' field values contain more characters/data than just 'bottle' or 'can'.

Show the customer names, order dates, individual order item ids (OrderDetailID) and quantity for all orders from customers with a contact name beginning with G Links to an external site.. Sort by customer name, then order date. (need Customers, Orders and OrderDetails). Hint: after the first JOIN, just add another JOIN -- ex. ...FROM Customers JOIN Orders USING (xxxx) JOIN OrderDetails USING (xxxxx)

Show the product names, quantity, price and total (quantity*price) for all OrderDetails records where the customer has customer id 2 or 4. Sort by customer name. (need Customers, Orders, OrderDetails, and Products)