Which of the following query finds the name of the sailors who have reserved at least two boats? Options: A . &nbspSELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ≠ r2.bid B . &nbspSELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid C . &nbspSELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid r2.bid D . &nbspAll of these

Which of the following query finds the name of the sailors who have reserved at

Question

Which of the following query finds the name of the sailors who have reserved at least two boats?

Options:

A . SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ≠ r2.bid

B . SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid

C . SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid r2.bid

D . All of these

Answer: Option C

Submit Your Solution Below and Earn Points !

Next Question

Question 1. Which of the following query finds the total rating of the sailors who have reserved boat "103"?....

Question 2. The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs....

Question 3. Which of the following is illegal?....

Question 4. Let the statement SELECT column1 FROM myTable; return 10 rows. The statement SELECT ALL column1 FROM myTable; will retur....myTable; return 10 rows. The statement SELECT ALL column1 FROM myTable; will return

Question 5. If a query involves NOT, AND, OR with no parenthesis....

Question 6. Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE. The SQL statement SELECT COUNT(*) F....FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE); prints

Question 7. Which of the following SQL commands can be used to add data to a database table?....

Question 8. Which of the following is NOT a type of SQL constraint?....

Question 9. Which of the following join is also called as an 'inner-join'?....

Question 10. What is an SQL virtual table that is constructed from other tables?....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI

Tabulation - Test Paper 2 Data Interpretation Reasoning & DI

Test Paper 1 Direction Sense Test Reasoning & DI

ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0

GFM Combined 1 Free Revision Test SAIL JO E-0