Bissoy.com
Doctors Medicines MCQs Q&A

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

Which of the following query finds the total rating of the sailors who have reserved boat "103"? Correct Answer SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

To find the total rating of the sailors who have reserved boat "103," you should use the SQL query SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103; (Option D). This query correctly joins the "sailors" and "reserves" tables on the sailor ID (s.sid) and specifies the boat ID (r.bid) to be "103." It then calculates the sum of the ratings (s.rating) of the sailors who have reserved this boat. Option D is the correct choice for achieving this result.

Related Questions

Consider the schema Sailors(sid, sname, rating, age) with the following data Sid Sname Rating age 22 Dustin 7 45 29 Borg 1 33 31 Pathy 8 55 32 Robert 8 25 58 Raghu 10 17 64 Herald 7 35 71 Vishnu 10 16 74 King 9 35 85 Archer 3 26 84 Bob 3 64 96 Flinch 3 17 For the query SELECT S.rating, AVG(S.age) AS avgage FROM Sailors S Where S.age >= 18 GROUP BY S.rating HAVING 1 < (SELECT COUNT(*) FROM Sailors S2 where S.rating = S2.rating) The number of rows returned is
What is the distance covered by boat N upstream in 5 hours? Which of the following option is sufficient alone to find the answer? A) Boat M is travelling downstream with 20% more downstream speed of boat N. Speed of boat M in still water is 10% more than the speed of boat N in still water. B) Boat M and Boat N are travelling downstream with speed 33 km/hr and 40 km/hr respectively and speed of boat M is still water is 2 times the speed of stream. C) Speed of boat M in still water is 6 km/hr less then speed of boat N in still water and speed of stream is 10 km/hr. D) Speed of stream is ½ times the speed of boat N in still water and downstream speed of boat M is 44 km/hr. E) Speed of stream is 10 km/hr and ratio of upstream speed of boat M and boat N is 3 : 2 respectively.
Consider the following relation schema Sailors(sid, sname, rating, age) Reserve(sid, bid, day) Boats(bid, bname, color) What is the equivalent of following relational algebra query in SQL query. πsname((σcolor= ‘red’Boats) ⨝ Reserves ⨝ Sailors)  
In the following question, two statements are numbered as A and B. On solving these statements we get quantities A and B respectively. Solve for the both quantities and chose the correct option. Quantity A: The ratio of speed of boat to speed of stream is 2 : 1, If the boat travels 162 km and come back to starting point in 36 hour. What is the difference between the time taken by the boat to go upstream and the time taken by the boat to go downstream? Quantity B: The speed of the stream is 6 km/hr and the distance travelled by the boat is 60 km. If the boat covered half distance upstream with usual speed and other half with double its speed, then it takes 7.5 hours less time than usual time to go upstream. Find the total time taken by the boat to go upstream and downstream?
Five boats took part in a race. Boat R finished before Boat M but behind Boat G. Boat A finished before Boat S but behind Boat M. Which boat came fourth in the race?
Which of the following query finds the names of the sailors who have reserved at least one boat?
Ratio between speed of boat P and Q in still water is 8∶6 and speed of current is 8 km/hr. Boat Q starts from A in the downstream,2 hours earlier than Boat P and it is found that Boat P is 32 km ahead of boat Q after 16 hours of its start. If boat P starts from point B in down steam at the same time and distance between A and B is 216 km, then find at what time boat P and Q meet each other.
Two boats go downstream from point X to Y. The faster boat covers the distance from X to Y, 1.5 times as fast as slower boat. It is known that for every hour slower boat lags behinds the faster boat by 8 km. however, if they go upstream, then the faster boat covers the distance from Y to X in half the time as the slower boat. Find the speed of the faster boat in still water?
S1: There have been many myths about women in world literature.
P: Odysseus found a way to save himself and his sailors from this evil fate.
Q: The sirens were beautiful maidens whose songs enchanted sailors on the seas.
R: Odysseus encounter with the sirens during his return home after the fall of Troy is typical of this.
S: Their songs were so captivating that the sailors swam towards them and died miserable deaths.
S6: He filled his rower's ears with wax and had himself bound to the mast so that he could hear the sweet singing without diving overboard to his death.

The Proper sequence should be:
A boat goes to upstream in a river at the speed of 18 km/hr. The speed of stream is 3 km/hr. A leakage is found in the base of boat which can drown the boat in 3 hours and a pipe is connected with boat can empty the whole water of boat in 6 hours. Find the distance cover by boat before it drowns.