SQL для тестировщика

Рассмотрим следующую схему:

STUDENTS(student_code, first_name, last_name, email,
phone_no, date_of_birth, honours_subject, percentage_of_marks);

Какой из запросов покажет имена студентов у которых основной предмет (honorous_subect) — English и процент оценок (percentage_of_marks) больше 80 или имена студентов, у которых основной предмет Spanish и процент оценок больше 80?

1️⃣ select first_name, last name from students where (honours_subject = “English” or honours_subject = “Spanish” ) and percentage_of_marks > 80;
2️⃣ select first_name, last name from students where honours_subject = “English” or honours_subject = “Spanish” and percentage_of_marks > 80;
3️⃣ select first_name, last name from students where (honours_subject = “English” or honours_subject = “Spanish” and percentage_of_marks > 80);
4️⃣ select first_name, last name from students where (honours_subject = “English”) or honours_subject = “Spanish” and percentage_of_marks > 80;

Ответить на вопрос можно ниже ⬇️

www.tg-me.com/ms/SQL для тестировщика/com.sql_for_qa/7

1.6K viewsedited  Oct 17, 2022 at 01:10

Рассмотрим следующую схему:

STUDENTS(student_code, first_name, last_name, email,
phone_no, date_of_birth, honours_subject, percentage_of_marks);

Какой из запросов покажет имена студентов у которых основной предмет (honorous_subect) — English и процент оценок (percentage_of_marks) больше 80 или имена студентов, у которых основной предмет Spanish и процент оценок больше 80?

1️⃣ select first_name, last name from students where (honours_subject = “English” or honours_subject = “Spanish” ) and percentage_of_marks > 80;
2️⃣ select first_name, last name from students where honours_subject = “English” or honours_subject = “Spanish” and percentage_of_marks > 80;
3️⃣ select first_name, last name from students where (honours_subject = “English” or honours_subject = “Spanish” and percentage_of_marks > 80);
4️⃣ select first_name, last name from students where (honours_subject = “English”) or honours_subject = “Spanish” and percentage_of_marks > 80;

Ответить на вопрос можно ниже ⬇️

BY SQL для тестировщика