Question
Data Science and Artificial Intelligence Question on SQL
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 ______.
Answer
The correct answer is 3.