The relation scheme given below is used to store information about the employees of a company, where empId is the key and deptId indicates the department to which the employee is assigned. Each employee is assigned to exactly one department.
emp(empId, name, gender, salary, deptId)
Consider the following SQL query:
select deptId, count(⋆)
from emp
where gender = "female" and salary > (select avg(salary) from emp)
group by deptId;
The above query gives, for each department in the company, the number of female employees whose salary is greater than the average salary of
A
female employees in the department.
B
employees in the department.
C
employees in the company.
D
female employees in the company.
2
GATE CSE 2019
Numerical
+2
-0
A relational database contains two tables Student and Performance as shown below :
The primary key of the Student table is Roll_no. For the Performance table, the columns Roll_no. and Subject_code together from the primary key. Consider the SQL query given below:
SELECT S.Student_name, sum (P.Marks)
FROM Student S, Performance P
WHERE P.Marks > 84
GROUP BY S.Student_name;
The number of rows returned by the above SQL query is _________.
Your input ____
3
GATE CSE 2016 Set 2
Numerical
+2
-0
Consider the following database table named $$water$$_$$schemes :$$
water_schemes
scheme_no
district_name
capacity
1
Ajmer
20
1
Bikaner
10
2
Bikaner
10
3
Bikaner
20
1
Churu
10
2
Churu
20
1
Dungargarh
10
The number of tuples returned by the following $$SQL$$ query is _______________.
with total(name, capacity) as
select district_name, sum(capacity)
from water_schemes
group by district_name
with total_avg(capacity) as
select avg(capacity)
from total
select name
from total, total_avg
where total.capacity ≥ total_avg.capacity
Your input ____
4
GATE CSE 2015 Set 1
Numerical
+2
-0
Consider the following relation:
Student
Roll_No
Student_Name
1
Raj
2
Rohit
3
Raj
Performance
Roll_No
Course
Marks
1
Math
80
1
English
70
2
Math
75
3
English
80
2
Physics
65
3
Math
80
Consider the following SQL query.
SELECT S.Student_Name, Sum(P.Marks)
FROM Student S, Performance P
WHERE S.Roll_No= P.Roll_No
GROUP BY S.STUDENT_Name
The numbers of rows that will be returned by the SQL query is___________.