Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Які команди дозволяють вивести прізвища викладачів, дату іспиту і назву предмета?
SELECT teacher.tch_name, progress.dat, subject.subj_name FROM teacher, subject
SELECT tch_nam, dat, subj_name FROM teacher, subject WHERE progress.id_subj=subject.id_subj AND ON subject.id_tch=teacher.id_tch
SELECT teacher.tch_name, progress.dat, subject.subj_name FROM teacher, subject WHERE progress.id_subj=subject.id_subj AND ON subject.id_tch= teacher. id_tch
SELECT DISTINCT teacher.tch_name, progress.dat, subject.subj_name FROM teacher INNER JOIN subject INNER JOIN progress ON progress.id_subj= subject.id_subj ON subject.id_tch= teacher.id_tch
SELECT DISTINCT teacher.tch_name, progress.dat, subject.subj_name FROM teacher INNER JOIN subject INNER JOIN progress
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!