Informacje

Autor(zy) Quentin Cappart
Termin Brak terminu
Limit zgłoszeń Bez limitu

Zaloguj się

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.


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