Combine the country name, continent and region separated by a space from the Countries table.

Select the recommended retail price discounted by 10% as DiscountedPrice and the stock item name concatenated with the search details separated by a space of records in the stock items table.

Select all sales order lines where the quantity is greater than the average sales quantity - use a sub query.

List customers that have customer transactions- use the IN operator. (3)

List customers that don't have customer transactions - use the NOT IN operator. (7)

Select stock item name, recommended retail price for stock items that have had a quantity ordered greater than 75 on order lines.

Select the product name and recommended retail price where the price is more than $40.

Select the customer name and website URL for customers that have placed orders before January 16, 2013.