Consider the Sailors-Boats-Reserves database. Which SQL queries answer this question? Find the names and ages of sailors who have reserved at least two different boats. Select one or more: a. SELECT distinct s.sname, s.age FROM sailors s, reserves r1 WHERE s.sid=r1.sid AND EXISTS (SELECT r2.sid FROM reserves r2 WHERE s.sid=r2.sid AND r1.bid<>r2.bid) Ob. OC. O d. SELECT distinct s.sname, s.age FROM sailors s, reserves r1, reserves r2 WHERE s.sid=r1.sid AND s.sid=r2.sid AND r1.bid = r2.bid SELECT distinct s.sname, s.age FROM sailors s, reserves r1, reserves r2 WHERE s.sid=r1.sid AND s.sid=r2.sid AND r1.bid<>r2.bid SELECT s.sname, s.age FROM sailors s, reserves r WHERE s.sid=r.sid GROUP BY s.sid, s.sname HAVING 2<= Count(r.bid) □e. SELECT s.sname, s.age FROM sailors s, reserves r WHERE s.sid=r.sid GROUP BY s.sid, s.age, s.sname HAVING 2<= Count(DISTINCT r.bid)

Consider the Sailors-Boats-Reserves database. Which SQL queries answer this question? Find the names and ages of sailors who have reserved at least two different boats. Select one or more: a. SELECT distinct s.sname, s.age FROM sailors s, reserves r1 WHERE s.sid=r1.sid AND EXISTS (SELECT r2.sid FROM reserves r2 WHERE s.sid=r2.sid AND r1.bid<>r2.bid) Ob. OC. O d. SELECT distinct s.sname, s.age FROM sailors s, reserves r1, reserves r2 WHERE s.sid=r1.sid AND s.sid=r2.sid AND r1.bid = r2.bid SELECT distinct s.sname, s.age FROM sailors s, reserves r1, reserves r2 WHERE s.sid=r1.sid AND s.sid=r2.sid AND r1.bid<>r2.bid SELECT s.sname, s.age FROM sailors s, reserves r WHERE s.sid=r.sid GROUP BY s.sid, s.sname HAVING 2<= Count(r.bid) □e. SELECT s.sname, s.age FROM sailors s, reserves r WHERE s.sid=r.sid GROUP BY s.sid, s.age, s.sname HAVING 2<= Count(DISTINCT r.bid)

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

Write the SQL code to delete the row for William Smithfield, who was hired on June 22, 2004, and whose job code is 500. (Hint: Use logical operators to include all of the information given in this problem.)
Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January 1, 1994, and whose job code is at least 501. (You may assume that the table will be restored to its condition preceding this question.)
Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student_id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation_year: expected year of graduation for the student "courses" table: course_id: unique identifier for the course course_name: name of the course instructor_name: name of the instructor teaching the course. department: department offering the course. course_description: description of the course "enrollments" table: enrollment_id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in…
Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student_id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation_year: expected year of graduation for the student "courses" table: course_id: unique identifier for the course course_name: name of the course instructor_name: name of the instructor teaching the course. department: department offering the course. course_description: description of the course "enrollments" table: enrollment_id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in…
Write SQL code for To Extend the code in ( Perform a LEFT OUTER JOIN between the tables Wicketkeeping and Batting. You may select any column(s). Look at the result and state how many wicketkeepers have not played as batsmen (no need to write code for this part) To show the name of the wicketkeeper(s) who have not played as a batsman. (syntax to check a NULL value in a column is: WHERE ColumnName IS NULL ) ?
Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student_id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation year: expected year of graduation for the student "courses" table: course id: unique identifier for the course course name: name of the course instructor name: name of the instructor teaching the course. department: department offering the course. course description: description of the course "enrollments" table: enrollment id: unique identifier for the enrollment student id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in enrollment date:…
Write and execute a SQL query to list all patient numbers and encounter ids which do not have any data (missing rows) in VisitSummary table. Order the result by patient number, encounter id. Write and execute a SQL query to list all patients whose information about race or gender has changed during their future visits. A future visit is defined as T1.encounter_id < T2.encounter_id. Your output should have patient number, old and new race values, old and new gender values, and the encounter ids. Write and execute a SQL query to list all the patient data for all encounters. Even if patient data is missing in other tables, you still need to list the patient_nbr and encounter_id in your output. Your output should list all the columns (without repeating them) starting with encounter_id, patient_nbr... and it should be ordered by patient_nbr and then encounter_id. Write and execute a SQL query to list all the patient data for all encounters. If the patient data is missing…
Write a SQL query. List names of all employees who have sold to customer Rachel Patterson (Note: You can only use the information given in the question, i.e. you cannot first look up Rachel Patterson’s Customer ID and use that ID in your query).
You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. You want to check for postal codes that are greater than 7 characters long. You write the SQL query below. Add a LENGTH function that will return any postal codes that are greater than 7 characters long.
Create table sales ( cust varchar(20), prod varchar(20), day integer, month integer, year integer, state char(2), quant integer, date date ) Using the given table, how can a query be generated in SQL that for each customer find the top 3 highest quantities purchased in New Jersery (NJ). Showing the customer's name, the quantity and product purchased, and the date they purchased it. If there are ties, show them all.
Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
Using HR Objects and Data For Live SQL Write down the SQL to show the average salary for each department together with its department name for its employees satisfying one of the following conditions: (1) hired after Jan-1-2008 or manager_id is 103, (2) salary is above 4000 and job_id starts with a letter “S”. In addition, when grouping the above selected employees by department, we only show the department which has more than 5 employees or the minimal salary greater than 5000, and order the result by the average salary.

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS