- Question 21 1 Point Listen The Sequence Created With The Serial Data Type Is Restricted To Use Within Only One Table 1 (17.01 KiB) Viewed 47 times
- Question 21 1 Point Listen The Sequence Created With The Serial Data Type Is Restricted To Use Within Only One Table 2 (33.18 KiB) Viewed 47 times
- Question 21 1 Point Listen The Sequence Created With The Serial Data Type Is Restricted To Use Within Only One Table 3 (44.44 KiB) Viewed 47 times
- Question 21 1 Point Listen The Sequence Created With The Serial Data Type Is Restricted To Use Within Only One Table 4 (47.29 KiB) Viewed 47 times
Question 3 (3 points) 4) 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 * D
Question 2 (3 points) E Listen Using the university schema, fill in the blanks of the following query to display a of all instructors, showing each instructor's ID and the number of sections that instructor taught. Make sure to show the number of sections as 0 for instructor who have not taught any section. SELECT ID, (_____ COUNT(*) AS secs_taught FROM teaches AS WHERE TT.ID = II. ID) instructor AS II; Blank # 1 Blank # 2 Blank #3 MARI 1000 1000 1 P Z
SELECT ID FROM student EXCEPT SELECT s_id FROM advisor WHERE i ID IS NOT NULL; Fill in the blank to express this query using no subqueries and no set operations. SELECT ID FROM student. WHERE i_id Blank # 1 Blank # 2 Blank # 3 Blank # 4 Blank # 5 Blank #6 L; advisor ON A/ DJ E A/ ‒‒‒‒‒ = s_id