Consider a relational database containing the following schemas.
The primary key of each table is indicated by underlining the constituent fields.
The number of rows returned by the above SQL query is

sql
- A4
- B5
- C0
- D2
Database Management Systems (DBMS)SQL Queries (DDL/DML, Joins, Aggregations)MCQ1 mark · −1/3 if wrongMedium

1SELECT s.sno, s.sname
2FROM Suppliers s, Catalogue c
3WHERE s.sno = c.sno AND
4 cost > (SELECT AVG (cost)
5 FROM Catalogue
6 WHERE pno = 'P4'
7 GROUP BY pno);
8A GATE question every morning
One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.