2.
By considering table club, give the output of the following SQL statements:
Lavanya
Coach- Coachname Age Sports Dateof app Pay Sex
ID
1
Rachit 35 Karate 27/03/1996 1000 M
2. Daksh 34 Karate 20/01/1998 2200 M
3
34 Squash 19/02/1998 2500 F
4
Ronit 33 Basketball 01/01/1998 1500 M
5
Keshav 36 Swimming 12/01/1998 1750 M
6 Krish 36 Swimming 24/02/1998 1800) M
7 Siddharth 39 Squash 20/02/1998 3200 M
8 Rydham 37 Karate 22/02/1998 2100) F
9 Parth
41 Swimming 13/01/1998 1900 M
a) Select Distinct Sports from Club;
b) Select Max(Age), Avg(age) from Club where SEX = "M";
Answers
Answered by
0
Answer:
Fo we have to crate a table in Sql?
Similar questions