Database table name Tuition_Records is given below
|
Students |
Teachers |
Fees |
|
Aniket |
Uday |
10000 |
|
Barbie |
Rishi |
7000 |
|
Chandresh |
Uday |
12000 |
|
Dharma |
Rishi |
9000 |
X ≡ (SELECT students, Teachers FROM Tuition_Records) AS A NATURAL JOIN (SELECT Teachers, Fees FROM Tuition_Records)
R ≡ SELECT count(*) FROM X
Which of the following is/are true?
1
Output of R is 8
2
In X, Teachers = "Uday" occurs 4 time
3
Output of R is 6
4
In X, Teachers = "Rishi" occurs 2 time