Published On Aug 24, 2023
Hello everyone,
In this video I have explained in detail the count(), sum(), and avg() functions in SQL with examples.
Keep Practicing using below sample data
CREATE TABLE Product (
product_id INT PRIMARY KEY,
product_name VARCHAR(100) NOT NULL,
price DECIMAL(10, 2) NOT NULL,
category VARCHAR(50)
);
INSERT INTO Product (product_id, product_name, price, category)
VALUES
(1, 'Product 1', 10.99, 'Electronics'),
(2, 'Product 2', 19.99, 'Clothing'),
(3, 'Product 3', 8.49, 'Home & Kitchen'),
(4, 'Product 4', 15.75, 'Toys'),
(5, 'Product 5', 12.50, 'Electronics'),
(6, 'Product 6', 9.99, 'Home & Kitchen'),
(7, 'Product 7', 11.25, 'Clothing'),
(8, 'Product 8', 14.95, 'Electronics'),
(9, 'Product 9', 7.99, 'Toys'),
(10, 'Product 10', 6.50, 'Home & Kitchen'),
(11, 'Product 11', 18.75, 'Clothing'),
(12, 'Product 12', 13.25, 'Electronics'),
(13, 'Product 13', 5.99, 'Home & Kitchen'),
(14, 'Product 14', 16.50, 'Clothing'),
(15, 'Product 15', 9.50, 'Toys'),
(16, 'Product 16', 12.99, 'Electronics'),
(17, 'Product 17', 7.25, 'Clothing'),
(18, 'Product 18', 8.99, 'Home & Kitchen'),
(19, 'Product 19', 14.50, 'Toys'),
(20, 'Product 20', 10.25, 'Electronics');
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
Subscribe Now and Stay Updated! 🔔
â–º Visit our website: https://visionforanalytics.com/
â–º Join our Facebook group: Â Â /Â 995887284773826Â Â