Question

6. (a) Create a marks 100 table having name, roll and marks attributes. Create another table with attributes:
name, roll and marks: Insert some tuples. Now write SQL statements for following queries:
10
(i) List roll and name of student who got > 75 in both subjects.
(i) List roll and name of student who got > 65 in either subjects.
(iii) List roll and name of student who got > 60 in mathematics only.​

Answer 1

Explanation:

hdhxjdjsjjdbsjzidjdjdondnsjxndnfjg