NGanch/goit-rdb-hw-05

goit-rdb-hw-05

SELECT order_details.*, (SELECT customer_id FROM orders WHERE orders.order_id = order_details.order_id) AS customer_id FROM order_details;

SELECT * FROM order_details WHERE order_id IN (SELECT order_id FROM orders WHERE shipper_id = 3);

SELECT order_id, AVG(quantity) AS avg_quantity FROM (SELECT * FROM order_details WHERE quantity > 10) AS orders_filtered GROUP BY order_id;

WITH temp AS ( SELECT * FROM order_details WHERE quantity > 10 ) SELECT order_id, AVG(quantity) AS avg_quantity FROM temp GROUP BY order_id;

-- Видаляємо функцію, якщо вона вже існує DROP FUNCTION IF EXISTS divide_function;

-- Створюємо нову функцію з вказанням ключового слова DETERMINISTIC DELIMITER //

CREATE FUNCTION divide_function(x FLOAT, y FLOAT) RETURNS FLOAT DETERMINISTIC BEGIN DECLARE result FLOAT; SET result = x / y; RETURN result; END//

DELIMITER ;

SELECT divide_function(quantity, 2) AS divided_quantity FROM order_details;