SQL Aggregate Functions - COUNT, SUM, AVG, MIN, MAX | 25 Examples | MySQL Database | MySQL Workbench
In this video, we’ll cover the most commonly used SQL aggregate functions—COUNT, SUM, AVG, MIN, and MAX. You’ll learn how to use these functions effectively with 25 real-world examples in a MySQL database using MySQL Workbench. Perfect for beginners and anyone preparing for database interviews or projects.
📌 What You Will Learn:
Using COUNT to count rows in a table
Calculating total values with SUM
Finding average values using AVG
Identifying the smallest (MIN) and largest (MAX) values in a dataset
25 hands-on examples with clear explanations
🎯 Who Should Watch:
Beginners learning SQL for the first time
Database developers working with MySQL
Anyone preparing for SQL-based interviews or projects
Subscribe for more SQL tutorials, hands-on examples, and database tips to improve your SQL skills.
#sql #mysql #sqlfunctions #databasetutorial #aggregatefunctions #mysqlworkbench #sqlqueries
SQL SCRIPT:
-------------------------------------------------------
CREATE DATABASE ems;
USE ems;
CREATE TABLE employees (
id INT PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NULL,
email VARCHAR(50) UNIQUE,
salary DECIMAL(10, 2),
department VARCHAR(50)
);
INSERT INTO employees
VALUES
(1, "Ramesh", "Fadatare", "[email protected]", 25000, "IT"),
(2, "Ram", "Jadhav", "[email protected]", 20000, "HR"),
(3, "Sita", "Patel", "[email protected]", 15000, "Sales"),
(4, "Arjun", NULL, "[email protected]", 20000, "IT"),
(5, "Priya", NULL, "[email protected]", 15000, "HR"),
(6, "Umesh", "Fadatare", "[email protected]", 20000, "IT");