How many students number in this table?
select count ( * ) from student
How many class rooms in this table?
select count ( class_room ) from class
Find the average gpa of the students?
select avg ( stu_gpa ) from student
What is last name of William?
select stu_lname from student where stu_fname = "William"