my-guitar-shop-database-exersices/How-to-retrieve-data-from-a-single-table.sql

-- Exercise 1
SELECT
	product_code, product_name, list_price, discount_percent
FROM
	products
ORDER BY
	list_price DESC;

-- Exercise 2
SELECT
	concat(last_name, ', ', first_name) AS full_name
FROM
	customers
WHERE
	last_name >= 'M'
ORDER BY
	last_name ASC;

-- Exercise 3
SELECT
	product_name, list_price, date_added
FROM
	products
WHERE
	list_price > 500 AND list_price < 2000;
ORDER BY
	date_added DESC;

-- Exercise 4
SELECT
	product_name,
    list_price,
    discount_percent,
	ROUND(list_price * discount_percent / 100) AS discount_amount,
	ROUND(list_price - (list_price * discount_percent), 2) AS discount_price
FROM
	products
ORDER BY
	discount_price DESC
LIMIT
	5;

-- Exercise 5
SELECT
	item_id,
    item_price,
    discount_amount,
    quantity,
    item_price * quantity AS price_total,
    discount_amount * quantity AS discount_total,
    (item_price - discount_amount) * quantity AS item_total
FROM
	order_items
WHERE
	(item_price - discount_amount) * quantity >= 500
ORDER BY
	item_total DESC;

-- Exercise 6
SELECT
	order_id,
    order_date,
    ship_date
FROM
	orders
WHERE
	ship_date IS NULL;

-- Exercise 7
SELECT
	NOW() AS today_unformatted,
    DATE_FORMAT(NOW(), "%d-%m-%Y") AS today_formatted;

-- Exercise 8
SELECT
	'100' AS 'price',
    '0.07' AS 'tax_rate',
    100 * .07 AS tax_amount,
    100 + (100 * .07) AS total;