06 Learn SQL Aggregations - Using COUNT, MAX, MIN, SUM, AVG скачать в хорошем качестве

06 Learn SQL Aggregations - Using COUNT, MAX, MIN, SUM, AVG

Learn how to use SQL aggregations such as COUNT, MAX, MIN, SUM, and AVG. Easy lesson to learn how to use SQL aggregations SQL Script to build database /* sample database to demonstrate aggregations */ CREATE DATABASE IF NOT EXISTS myLesson; USE myLesson DROP TABLE IF EXISTS product; CREATE TABLE product ( productID INT PRIMARY KEY, productCode CHAR(5), productName VARCHAR(25), productCategory VARCHAR(10), productCost NUMERIC(6,2), productSell NUMERIC(7,2) ); INSERT INTO product VALUES (1,'XYZ12','Product 1','Hardware', 3.40, 8.10), (2,NULL,'Product 2', 'Software',4.50, NULL), (3,'KJH78','Product 3', 'Hardware', 6.10, 12.40), (4,'HGT23','Product 4', 'Misc.',1.40, 4.10), (5,'GTY64','Product 5', 'Software', 5.80, 8.10), (6,NULL,'Product 6', 'Hardware', NULL, NULL), (7,'NVF32','Product 7', 'Hardware', 2.40, 6.20), (8,'IUY98','Product 8', 'Misc.', 12.15, 15.99), (9,'YSD56','Product 9', 'Software',8.45, 12.75), (10,'LQW37','Product 10', 'Software',2.60, 6.39); COMMIT;