What is the average age of students?
select avg ( age ) from student
What is the average age of students as per the "Sex" of the students?
select sex,avg ( age ) from student group by sex
How many Students are below the age of 17?
select count ( stuid ) from student where age<17
How many students have the same Fname?
select count ( stuid ) from student where fname in ( select fname from student group by fname having count ( * ) >1 )
How many clubs are located in city code "AKW"
select count ( clubid ) from club where clublocation = 'AKW'
and how many in city code "HHH"
select count ( clubid ) from club where clublocation = 'HHH'