Help with mysql workbench a) Find the lowest, across all departments, of the per

Question

Help with mysql workbench

a) Find the lowest, across all departments, of the per-department maximum salary computed by the preceding query.

b)Find the name(s) of the department that has the most instructors.

c)Find the unique names of the students that took all the classes taken by the student with id "1018"

d)Find the titles of the 4-credit courses offered by the Biology department.

e)Find the course titles of the largest capacity sections taught in 2003 (ie taught in a classroom with the maximum room capacity)

f)Find the grade distribution (frequencies) for the courses taught in 2005 by the Finance department.

ID CHAR dept_name VARCHAR(20) CHAR(20) ing VARO dept_name VARCHAR(20) tot cred takes nstructor ARCH name VARCHAR(20) sec_id VARCHAR mester VARCHAR ept_name VARCHAR(20) sa MAL(8,2) grade VARCHAR(2 VARCHAR VARCHAR ache VARCHAR course_id VARCHAR sec_id VARCHA sec course mes semester VARCHAR ng VARCHAR room number VARCHAR(7) time_slot_id VARCHAR CHAR RCHAR(50) dept_name CHAR(20) ime sroo time_slot_id VARCHAR VARCHAR room_number VARCHAR(7) urse ARCHAR req_id VARCHAR end hr DECIMAL(2

Explanation / Answer

a) select min(maximum_salary)
from (select dept_name,max(salary) as maximum_salary
from instructor
group by dept_name);

b)select dept_name from instructor group by dept_name;

c)select distinct(name) from student where id='1018';

d)select title from course where dept_name='Biology' and credits='4';

e)select title from course where course_id in (select course_id from section where year='2003' and exists(select max(capacity) from classroom));

f)select distinct(grade) from takes where year='2005' and id in(select id from student where dept_name =(select dept_name from department where dept_name='Finance'));

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.