AGGREGATE FUNCTIONS

 CREATE DATABASE students;

USE students;

CREATE TABLE info(id int primary key,name varchar(90),address varchar(199), marks int, grade varchar(10));

INSERT INTO info(id,name,address,marks,grade)

values(1,'abhi','kmm',80,'A'),

(2,'bharath','hyd',75,'A'),

(3,'ash','kmr',79,'A'),

(11,'viany','kmr',88,'A'),

(4,'joe','us',89,'A'),

(5,'katy','mum',69,'B'),

(69,'dani','kmm',56,'C'),

(6,'lana','kmm',33,'F'),

(7,'thala','jrknd',100,'O'),

(8,'jaddu','guj','97','O'),

(10,'god','mumbai','100','O'),

(18,'king','delhi',100,'O'),

(45,'shana','mumbai',87,'A'),

(17,'alien','ban',199,'F');

USE students;

SHOW TABLES;

SELECT count(marks) FROM info;

SELECT MAX(marks) FROM info LIMIT 5 ;

SELECT MAX(address) FROM info ;

SELECT MIN(marks) FROM info;

SELECT SUM(marks) FROM info;

SELECT AVG(marks) FROM info;

USE students;

SELECT address, COUNT(marks) FROM info GROUP BY address;

SELECT address, COUNT(id) FROM info GROUP BY address;

SELECT address,AVG(marks) FROM info GROUP BY address;

SELECT address,AVG(marks) FROM info GROUP BY address ORDER BY AVG(marks);

SELECT grade,COUNT(id) FROM info GROUP BY grade;

SELECT address, COUNT(name) FROM info GROUP BY address HAVING MAX(marks) >90;