Write an SQL statement that getsa count of overworked instructors for each department, subject to the following constraints:-An overworked instructor is one who has taught more than the average number of classes. Note that instructors who have not taught any classes should be included in the calculation of the average.-Listthe departments with the more overworked instructors before those with fewer overworked instructors-Use the keyword onsomewhere in your answer. -Hint: You may want to use a with clause with multiple subqueries to answer this, i. e.:with a as (select *...), b as (select * ...) select * from a, b ...

Multiple choice project create a program with two multiple choice questions. 1. users have two attempts only, show attempt number each time. hint: while loop with break control. (20%) 2. only one correct answer for each question, use switch case for each question. (20%) 3. show total score after the two questions are answered. hint: . (20%) 4. user have options to answer the two questions again if first attempt score is not 100%. hint: if statment. (20%) 5. use string method .toupper() to allow users to enter with lowercase or uppercase letters. (20%) 1. where is the capital of the state of florida? a. orlando b. tallahassee c. miami d. tampa b 2. where is walt disney world park located in florida? a. orlando b. tallahassee c. miami d. tampa a