-- q1

SELECT * FROM OrderItems oi
inner join Product ON oi.idProduct = Product.idProduct
WHERE Product.unit_price BETWEEN 1000000 AND 1010000;



-- q2

SELECT COUNT(*),SUM(oi.quantity) FROM OrderItems oi
inner join Product ON oi.idProduct = Product.idProduct
WHERE Product.unit_price BETWEEN 1000000 AND 1010000;


---- q3

SELECT * FROM OrderItems oi
inner join Product ON oi.idProduct = Product.idProduct
inner join "Order" ON oi.idOrder = "Order".idOrder
WHERE Product.name LIKE 'Auto%' AND EXTRACT (YEAR FROM "Order".order_datetime) = 2022 AND oi.unit_price BETWEEN 1000000 AND 1010000;