A table 'student' with schema (roll, name, hostel, marks), and another table 'hobby' with schema (roll, hobbyname) contains records as shown below:Table: StudentROLL NAME HOSTEL MARKS1798 Manoj Rathod 7 952154 Soumic Banerjee 5 682369 Gumma Reddy 7 862581 Pradeep Pendse 6 922643 Suhas Kulkarni 5 782711 Nitin Kadam 8 722872 Kiran Vora 5 922926 Manoj Kunkalikar 5 942959 Hemant Karkhanis 7 883125 Rajesh Doshi 5 82 Table: hobbyROLL HOBBYNAME1798 chess1798 music2154 music2369 swimming2581 cricket2643 chess2643 hockey2711 volleyball2872 football2926 cricket2959 photography3125 music3125 chess The following SQL query is executed on the above tables:select hostelfrom student natural join hobbywhere marks > = 75 and roll between 2000 and 3000;Relations S and H with the same schema as those of these two tables respectively contain the same information as tuples. A new relation S’ is obtained by the following relational algebra operation: S’ = ∏hostel ((σs.roll = H.roll (σmarks > 75 and roll > 2000 and roll < 3000 (S)) X (H)) The difference between the number of rows output by the SQL statement and the number of tuples in S’ is

A table 'student' with schema (roll, name, hostel, marks), and another

1.	A table 'student' with schema (roll, name, hostel, marks), and another table 'hobby' with schema (roll, hobbyname) contains records as shown below:Table: StudentROLL NAME HOSTEL MARKS1798 Manoj Rathod 7 952154 Soumic Banerjee 5 682369 Gumma Reddy 7 862581 Pradeep Pendse 6 922643 Suhas Kulkarni 5 782711 Nitin Kadam 8 722872 Kiran Vora 5 922926 Manoj Kunkalikar 5 942959 Hemant Karkhanis 7 883125 Rajesh Doshi 5 82 Table: hobbyROLL HOBBYNAME1798 chess1798 music2154 music2369 swimming2581 cricket2643 chess2643 hockey2711 volleyball2872 football2926 cricket2959 photography3125 music3125 chess The following SQL query is executed on the above tables:select hostelfrom student natural join hobbywhere marks > = 75 and roll between 2000 and 3000;Relations S and H with the same schema as those of these two tables respectively contain the same information as tuples. A new relation S’ is obtained by the following relational algebra operation: S’ = ∏hostel ((σs.roll = H.roll (σmarks > 75 and roll > 2000 and roll < 3000 (S)) X (H)) The difference between the number of rows output by the SQL statement and the number of tuples in S’ is
A.	6
B.	4
C.	2
D.	0
Answer» C. 2