You are not logged in.

#1 2015-09-18 06:39:32

husnain
User RankUser RankUser RankUser RankUser RankUser Rank
Administrator
From: Chichawatni,Pakistan
Registered: 2014-10-03
Posts: 8,129
Website

SQL Total Rating:

Database Quizzes SQL

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

Option A):
SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
Option B):
SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
Option C):
SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

Correct Answer is Option B):
SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103


You cannot discover the new oceans unless you have the courage to lose the sight of the shore.

2015-09-18 06:39:32

Advertisement
Ads By Google

Re: SQL Total Rating:



Board footer