Database Management Systems

13. Which of the following query finds the total rating of the sailors who have reserved boat "102"? 1) SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 102; II) SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 102 III) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid r.sid AND r.bid = 102 IV) SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid =r.sid AND r.bid = 102 You can also see the options in the below figure rating 8 3 3 1 Sailors sid sname 32 Andy 85 Art 95 Bob 29 Brutus 22 Dustin 64 Horatio 74 Horatio 31 Lubber 58 Rusty 71 Zorba age 25.5 25.5 63.5 33 45 35 Reserves sid bid 22 101 22 102 22 103 22 104 31 102 31 103 31 104 64 101 64 102 74 103 77198 day 2021-10-10 2021-10-10 2021-10-8 2021-10-7 2021-11-10 2021-11-6 2021-11-12 2021-9-5 2021-9-8 2021-9-8 35 55.5 10 35 16 10 Boats bid 101 102 103 104 bname Interlake Interlake Clipper Marine color Blue Red Green Red 1) SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 102 11) SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 102 III) SELECT COUNT(s.rating) FROM sailors , reserves r WHERE s.sid =r.sid AND r.bid = 102 IV) SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid =r.sid AND r.bid = 102 a) O IV b) O II c) O III d) 1