Kurs-Liste Einloggen

Information

Author(s) Quentin Cappart
Deadline Keine Frist
Abgabenlimit No limitation

Einloggen

Einloggen

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.

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