Q1. List out some of the aggregate functions in SQL,
Q2. Table: Student
Roll
Name
Mark
AA
100
BB
91
3
80
DD
50
5
EE
95
6
FF
NULL
GG
100
Grade
А
А
с
D
А
E
А
Class
XII
XII
XI
XI
Х
Х
XII
From the above table find output:
i Select avg(marks) from Student;
ii. Select count(*) "Total-Rows" from Student;
ini. Select count( distinct class) from Student;
iv. Select max(Mark) from Student;
v. Select min(Mark) from Student;
vi. Select sum(Mark) from Student;
vii. Select sum(Mark) from Student where mark90;
viil. Select avg(Mark) from Student where Class='XII' and Mark>90;
Q3 Differentiate between
Answers
Answered by
0
Answer:
master jesus told diaz hi kate moss has who you knew existed about how your convenience email me addresses anonymous private investor equity investment7y74784 jaha jha jana jha tak news updates entertainment industry professionals throughout my minnesota wisconsin wyoming madison university east anglia brunswick maine school district judge william morris and then i'm not hoping they that should they got caught it
Similar questions