SQL Basics Part - II | Explanation of Aggregate Functions (Count, Sum, Avg, Min, Max) with LIVE SQL
This video demonstrates how to use the SQL Aggregate Functions with LIVE demo on SQL Server. The Aggregate Functions explained in this video are as under.
1. COUNT
2. SUM
3. AVG
4. MIN
5. MAX
Also have covered the usage of ISNULL and GROUP BY functions along with the Aggregate Function explanation
For SQL Server Installation, Please watch this video : • How to Install SQL Server 2022 Databa...
For SQL Server Management Studio (SSMS) Installation and usage, please refer this video : • How to Install SQL Server Management ...
For SQL Server Database Creation, Please refer this video : • How to Create a New Database in SQL S...
The statements used for this video is as under for your practice.
/* DROPPING OLD TABLE */
DROP TABLE STUDENT
/* CREATING A NEW TABLE FOR AGGREGATE FUNCTIONS */
CREATE TABLE STUDENT (
STUDENT_ID VARCHAR(10),
STUDENT_NAME VARCHAR(30) NOT NULL,
DEPARTMENT VARCHAR(50) NOT NULL,
STUDENT_AGE NUMERIC(2),
OVERALL_MARKS NUMERIC(5,2)
CONSTRAINT PK_STUDENT PRIMARY KEY(STUDENT_ID)
)
/* INSERTING SAMPLE VALUES FOR AGGREGATE FUNCTIONS */
INSERT INTO STUDENT VALUES ('10010','JESSY','COMPUTER SCIENCE',19,87.2)
INSERT INTO STUDENT VALUES ('10011','JACK','IT',20,86.4)
INSERT INTO STUDENT VALUES ('10012','MIKE','MECHANICAL',21,75.9)
INSERT INTO STUDENT VALUES ('10013','ZOYA','ELECTRONICS',20,92.4)
INSERT INTO STUDENT VALUES ('10014','STARK','AERONAUTICS',20,85)
INSERT INTO STUDENT VALUES ('10015','JONES','MECHANICAL',20,76)
INSERT INTO STUDENT VALUES ('10016','MONICA','IT',21,92.8)
INSERT INTO STUDENT VALUES ('10017','JIM','MECHANICAL',20,NULL)
/* UPDATE STATEMENT FOR NULL COLUMN */
UPDATE STUDENT SET OVERALL_MARKS = 75.2 WHERE STUDENT_ID = '10017'
