Table: university_staff
Columns: department
head
full_professors
honorary_professors
lecturers

Question: How many full professors work under Hartmut Kliemt with more than 0 lecturers?
SQL: SELECT COUNT("full_professors") FROM university_staff WHERE "head" = 'hartmut kliemt' AND "lecturers" > 0

Question: What is the least amount of lecturers in the accounting department with less than 5 full professors?
SQL: SELECT MIN("lecturers") FROM university_staff WHERE "department" = 'accounting' AND "full_professors" < 5

Question: What is the average number of honorary professors in the economics department with 1 lecturer?
SQL: SELECT AVG("honorary_professors") FROM university_staff WHERE "lecturers" = 1 AND "department" = 'economics'