practice_bycicles

-- Select the product details, quantity, and location of bicycles in stock
SELECT
	product_name,
	category_name,
	list_price,
	quantity,
	store_id
FROM products
	INNER JOIN stocks ON products.product_id = stocks.product_id
	INNER JOIN categories ON products.category_id = categories.category_id
ORDER BY product_name

SELECT brand_id
FROM brands;

SELECT COUNT(brand_id) AS count_brand
FROM brands;

SELECT COUNT (list_price) AS high_price
FROM products
WHERE list_price >= 20;

SELECT COUNT (list_price) AS high_price
FROM products
WHERE list_price >=1000;

SELECT
product_id,
product_name,
brand_id,
category_id,
model_year,
list_price
FROM products;

SELECT COUNT (model_year) AS year_m, COUNT (list_price) AS price_l
FROM products	
WHERE model_year >=500;