Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Help with mysql workbench

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions