first name
select city_code from student where fname = "Smith"
What age of last name Kim?
select age from student where lname = "Kim"
What are the student id of city code WAS?
select stuid from student where city_code = "WAS"
Which major has least number of students? List the major and the number of students.
select major, count ( * ) from student group by major order by count ( major ) asc limit 1