SQL in Telugu - Count, Sum and Avg functions in SQL with examples || Functions in SQL
TeluguTechCoder TeluguTechCoder
966 subscribers
99 views
6

 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  

show more

Share/Embed