- Question 14 1 Point Listen Fill In The Missing Keywords From The Following Case Construct Syntax Case End Blank 1 B 1 (36.68 KiB) Viewed 40 times
- Question 14 1 Point Listen Fill In The Missing Keywords From The Following Case Construct Syntax Case End Blank 1 B 2 (35.16 KiB) Viewed 40 times
- Question 14 1 Point Listen Fill In The Missing Keywords From The Following Case Construct Syntax Case End Blank 1 B 3 (44.94 KiB) Viewed 40 times
- Question 14 1 Point Listen Fill In The Missing Keywords From The Following Case Construct Syntax Case End Blank 1 B 4 (45.65 KiB) Viewed 40 times
- Question 14 1 Point Listen Fill In The Missing Keywords From The Following Case Construct Syntax Case End Blank 1 B 5 (34.31 KiB) Viewed 40 times
Question 7 (3 points) Listen Using the university schema, display the list of all departments with the total number of instructors in each department without using subqueries. Make sure to show departments that have no instructors, and list those departments with an instructor count of zero. SELECT dept_name, AS fac_num FROM department NATURAL LEFT dept_name; Blank # 1 Blank # 2 Blank # 3 Blank # 4 JOIN instructor PJ N
Question 4 (3 points) E) Listen For the employee database schema given below, fill in the blanks to finish the query that finds the IDs of each employee with no manager. Note that an employee may simply have no manager listed or may have a null manager. Use an outer join expression. If you need to test these queries, you could create the database and populate it with a few example tuples. employee (ID, person_name, street, city) works (ID, company_name, salary) company (company_name, city) manages (ID, manager_ID) SELECT ID FROM WHERE Blank # 1 RI IS NULL; manages
SELECT * FROM student NATURAL LEFT OUTER JOIN takes; Rewritten Query: SELECT * FROM student NATURAL UNION SELECT ___, name, -1111) FROM student AS SS WHERE Blank # 1 Blank # 2 Blank #3 Blank # 4 Blank # 5 takes 11111) tot cred, NULL, NULL, NULL, NULL, NULL EXISTS (SELECT ID FROM AS TT WHERE TT.ID = SS.ID); I BU SAN. A K P A/ Z
Question 6 (3 points) Listen Using the university schema, fill in the blank to rewrite the query SELECT * FROM section NATURAL JOIN classroom; without using a NATURAL JOIN, but instead using an INNER JOIN with a USING condition. Note that the blank contains the entire FROM clause, and is not one single word. Note the semicolon has been included in the query. SELECT * A