GATEverse Practice, past papers & mock tests
GATE 2016 · CS2 - Afternoon
Database ManagementStructured Query Language (SQL)mediumNAT2 marks
Consider table water_schemes(scheme_no, district_name, capacity) with data for Ajmer (20), Bikaner (10, 10, 20), Churu (10, 20), Dungargarh (10). Query counts districts with sum(capacity) > avg(total capacity across districts). Number of tuples returned is _______
Save your progress

Related Database Management PYQs