Λίστα με τα μαθήματα Συνδεθείτε

Information

Deadline Καμία προθεσμία
Submission limit No limitation

Συνδεθείτε

Συνδεθείτε

Compréhension des mots-clefs (opérations d'agrégation)

Parmi les propositions suivantes, trouvez celle donnant une description correcte des mots-clefs (ou requêtes) suivants.

Question 1: 
select dept_name, count(*)
from student
group by dept_name;
Question 2: 
select avg(salary)
from instructor
where dept_name = 'Biology';
Question 3: 
select max(tot_cred)
from student;
Question 4: 
select dept_name
from instructor
group by dept_name
having count(*) > 5;
Question 5: 
select dept_name
from instructor
group by dept_name
having avg(salary) > 80000;
Question 6: 
select dept_name
from instructor
where avg(salary) > 80000
group by dept_name;
Question 7: 
select dept_name, name
from instructor
group by dept_name;
Question 8: 
select dept_name
from department
having budget > 1000000;
Question 9: 
select dept_name
from student
where count(*) > 10
group by dept_name;
Question 10: 
select dept_name, avg(salary)
from instructor
having avg(salary) > 80000
group by dept_name;