Yes, hi, I'd like to know how many professors are in the history department?
select count ( * ) from professor where dept_code = "HIST"
Do both of them have doctorates?
select count ( * ) from professor where dept_code = "HIST" and prof_high_degree = "Ph.d."
How many departments are there total?
select count ( distinct dept_code ) from professor
Is English one of them?
select distinct dept_code from professor where dept_code = "ENG"
Do any of the English professors have a PhD?
select count ( * ) from professor where dept_code = "ENG" and prof_high_degree = "Ph.d."
Can you tell me where the history Doctorate's office is?
select prof_office from professor where dept_code = "HIST" and prof_high_degree = "Ph.d."
What is the total number professors with doctorates employed by the 11 departments?
select count ( * ) from professor where prof_high_degree = "Ph.d."
Of those 18, how many doctorates are employed by the accounting department?
select count ( * ) from professor where prof_high_degree = "Ph.d." and dept_code = "ACCT"
Can you tell me where their offices are?
select prof_office from professor where prof_high_degree = "Ph.d." and dept_code = "ACCT"
Can you tell me the extension for the professor in office KLR229D, please?
select prof_extension from professor where prof_high_degree = "Ph.d." and dept_code = "ACCT" and prof_office = "KLR 229D"