запросы по опбд 2

2024-12-13 15:35 | Публичная
select * from course, exams, student where id_student=rk_student and id_course=rk_course
select surname, date_start, title, hours, score from (select * from course, exams, student where id_student=rk_student and id_course=rk_course 

and score=2) as my_subquery
select surname, date_start, title, hours, score from (select * from course, exams, student where id_student=rk_student and id_course=rk_course 

and score>2 and title='Информатика') as my_subquery
Вернуться ко Всем Вставкам
Открыть чат
Чат с Send-Code AI Закрыть чат