Tell me the last name, age and first name for the student id 1003 and 1004...
select lname, age, fname from student where stuid = 1003 or stuid = 1004
Tell me the sex of 1005 and 1004 and their city code ..
select sex, city_code from student where stuid = 1005 or stuid = 1004
Tell me total number of Male students and total number of female students.....
select sex, count ( * ) from student group by sex
Find the last name of female (Sex as F) students in the descending order of age.
select lname from student where sex = "F" order by age desc