DB Q:

simple answer please.

Rewrite the query below that returns the name and budget of all departments with more than 12 instructors, using the with clause instead of using a function call. create function dept_count(dept_name varchar(20)) returns integer begin declare d_count integer; select count(*) into d_count from instructor where instructor.dept_name = dept_name return d_count; end select dept_name, budget from department where dept_count(dept_name) > 12