MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
Which of the following query finds the name of the sailors who have reserved at least two boats?%! |
| 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» D. All of these | |