Give all details about the professor with the last name Graztevski?
select * from employee where emp_lname = 'Graztevski'
Which classes does he teach? Return the class code.
select t2.crs_code from employee as t1 join class as t2 on t1.emp_num = t2.prof_num where t1.emp_lname = 'Graztevski'
How many classes does he teach?
select count(*) from employee as t1 join class as t2 on t1.emp_num = t2.prof_num where t1.emp_lname = 'Graztevski'