Kursliste Logg inn

Informasjon

Forfatter(e) Quentin Cappart
Frist Ingen frist
Innleveringsgrense Ingen begrensning

Logg inn

Logg inn

Compréhension des mots-clefs (général)

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

Spørsmål 1: 
select name as student_name
from student;
Spørsmål 2: 
select name
from student
order by tot_cred;
Spørsmål 3: 
select name
from instructor
order by salary desc;
Spørsmål 4: 
select title
from course
order by title asc;
Spørsmål 5: 
select name
from student
order by tot_cred desc
limit 5;
Spørsmål 6: 
select name
from student
order by ID
limit 10 offset 5;
Spørsmål 7: 
select upper(name)
from instructor;
Spørsmål 8: 
select name
from student
where length(name) > 5;
Spørsmål 9: 
select name || ' (' || dept_name || ')'
from student;
Spørsmål 10: 
select lower(name) || '@univ.edu'
from instructor;