Вивести прізвища, імена та оцінки студентів.:

Question

Answer

SELECT STUDENTS.SFAM, STUDENTS.SNAME, USPISH.OCINKA FROM STUDENTS, USPISH

Answer

SELECT SFAM, SNAME, OCINKA FROM STUDENTS, USPISH WHERE STUDENTS.SNOM=USPISH.SNOM

Answer

SELECT STUDENTS.SFAM, STUDENTS.SNAME FROM STUDENTS UNION SELECT USPISH.OCINKA FROM USPISH

Answer

SELECT STUDENTS.SFAM, STUDENTS.SNAME, USPISH.OCINKA FROM STUDENTS, USPISH WHERE STUDENTS.SNOM=USPISH.SNOM

Answer

SELECT STUDENTS.SFAM, STUDENTS.SNAME, USPISH.OCINKA FROM STUDENTS INNER JOIN USPISH ON STUDENTS.SNOM=USPISH.SNOM

Crowdly