Consider the following two tables named Raider and Team in a relational database maintained by a Kabaddi league. The attribute ID in table Team references the primary key of the Raider table, ID.Raider ID Name Raids RaidPoints 1 Arjun 200 250 2 Ankush 190 219 3 Sunil 150 200 4 Reza 150 190 5 Pratham 175 220 6 Gopal 193 215
Team City ID BidPoints Jaipur 2 200 Patna 3 195 Hyderabad 5 175 Jaipur 1 250 Patna 4 200 Jaipur 6 200
The SQL query described below is executed on this database :
SELECT *
FROM Raider, Team WHERE Raider.ID=Team.ID AND City="Jaipur" AND
RaidPoints > 200;
The number of rows returned by this query is ______.
| Raider | |||
| ID | Name | Raids | RaidPoints |
| 1 | Arjun | 200 | 250 |
| 2 | Ankush | 190 | 219 |
| 3 | Sunil | 150 | 200 |
| 4 | Reza | 150 | 190 |
| 5 | Pratham | 175 | 220 |
| 6 | Gopal | 193 | 215 |
| Team | ||
| City | ID | BidPoints |
| Jaipur | 2 | 200 |
| Patna | 3 | 195 |
| Hyderabad | 5 | 175 |
| Jaipur | 1 | 250 |
| Patna | 4 | 200 |
| Jaipur | 6 | 200 |
The SQL query described below is executed on this database :
SELECT *
FROM Raider, Team WHERE Raider.ID=Team.ID AND City="Jaipur" AND
RaidPoints > 200;
The number of rows returned by this query is ______.
Correct Answer: 3
Solution and Explanation
Top Questions on SQL
- Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 values and D2 takes 2 values, and all combinations of these values are present in the table Facts. How many tuples are there in the result of the following query? \[ \text{SELECT D1, D2, sum(val)} \] \[ \text{FROM Facts} \] \[ \text{GROUP BY CUBE (D1, D2);} \]
On a relation named Loan of a bank:
- Given the table facts: \[ \text{facts (D1, D2, val)} \] with the following data:
Consider the following SQL query:
What is the total number of rows produced? - Amit wants to be familiar with SQL. One of his friends Anand suggests him to execute the following SQL commands:
(A) Create Table Student
(B) Use Database DB
(C) Select * from Student
(D) Insert into Student
In which order Amit needs to run the above commands? - Which SQL expression calculates the square root of 16?
Questions Asked in GATE AR exam
- Two cars, P and Q, start from a point X in India at 10 AM. Car P travels North with a speed of 25 km/h and car Q travels East with a speed of 30 km/h. Car P travels continuously but car Q stops for some time after traveling for one hour. If both cars are at the same distance from X at 11:30 AM, for how long (in minutes) did car Q stop?
- GATE AR - 2025
- GATE ME - 2025
- GATE PE - 2025
- Direction sense
Fish : Shoal :: Lion : _________
Select the correct option to complete the analogy.- GATE AR - 2025
- GATE ME - 2025
- GATE PE - 2025
- Verbal Analogies
- Which one of the following options has the correct sequence of objects arranged in the increasing number of mirror lines (lines of symmetry)?
P and Q play chess frequently against each other. Of these matches, P has won 80% of the matches, drawn 15% of the matches, and lost 5% of the matches.
If they play 3 more matches, what is the probability of P winning exactly 2 of these 3 matches?The given figure is reflected about the horizontal dashed line and then rotated clockwise by 90° about an axis perpendicular to the plane of the figure.
Which one of the following options correctly shows the resultant figure?
Note: The figures shown are representative
- GATE AR - 2025
- GATE ME - 2025
- GATE PE - 2025
- Logical Reasoning