/* 018 Count, Sum, Min, Max, Avg */ -- create table CREATE TABLE tOne( id INT NOT NULL UNIQUE, name VARCHAR(50) NOT NULL, percentage INT NOT NULL, age INT NOT NULL CHECK(age >= 18), gender VARCHAR(1) NOT NULL, phone VARCHAR(10) NOT NULL UNIQUE, city VARCHAR(15) NOT NULL DEFAULT 'Agra' ); -- insert records INSERT INTO tOne(id,name,age,gender,phone,city) VALUES (1,"Ram Kumar","23","M","4022155","Agra"), (2,"Sarita Kumari","21","F","4034421","Delhi"), (3,"Salman Khan","20","M","4056221","Agra"), (4,"Juhi Chawla","28","F","4022156","Bhopal"), (5,"Anil Kapoor","22","M","4025221","Agra"), (6,"John Abraham","21","M","4056776","Delhi"), (7,"Shahid Kapoor","20","M","4022784","Agra"); -- COUNT SELECT COUNT(name) FROM tOne; -- count name only SELECT COUNT(*) FROM tOne; SELECT COUNT(DISTINCT city) FROM tOne; -- count only unique city SELECT COUNT(DISTINCT city) AS Count FROM tOne; -- give name to the heading -- MAX SELECT MAX(age) AS age FROM tOne; -- MIN SELECT MIN(age) AS age FROM tOne; SELECT MIN(age) AS age,name,city FROM tOne; -- SUM SELECT SUM(age) AS Total FROM tOne; -- AVG SELECT AVG(percentage) AS Average FROM tOne;