Kursliste Logg inn

Informasjon

Frist Ingen frist
Innleveringsgrense Ingen begrensning

Logg inn

Logg inn

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.

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