Question 34 Consider the following database table named water_schemes : The number of tuples returned by the following SQL query is _________. with total(name, capacity) as […]

Question 35 Consider the following database table named top_scorer. SELECT ta.player FROM top_scorer AS ta WHERE ta.goals > ALL (SELECT tb.goals FROM top_scorer AS tb WHERE […]

Question 38 Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on […]

Question 45 Consider a relation geq which represents “greater than or equal to”, that is, (x,y) ∈ geq only if y >= x. create table geq […]