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

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;

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



tg-me.com/sql_for_qa/7
Create:
Last Update:

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

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 для тестировщика


Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/7

View MORE
Open in Telegram


SQL для тестировщика Telegram | DID YOU KNOW?

Date: |

A project of our size needs at least a few hundred million dollars per year to keep going,” Mr. Durov wrote in his public channel on Telegram late last year. “While doing that, we will remain independent and stay true to our values, redefining how a tech company should operate.

Telegram and Signal Havens for Right-Wing Extremists

Since the violent storming of Capitol Hill and subsequent ban of former U.S. President Donald Trump from Facebook and Twitter, the removal of Parler from Amazon’s servers, and the de-platforming of incendiary right-wing content, messaging services Telegram and Signal have seen a deluge of new users. In January alone, Telegram reported 90 million new accounts. Its founder, Pavel Durov, described this as “the largest digital migration in human history.” Signal reportedly doubled its user base to 40 million people and became the most downloaded app in 70 countries. The two services rely on encryption to protect the privacy of user communication, which has made them popular with protesters seeking to conceal their identities against repressive governments in places like Belarus, Hong Kong, and Iran. But the same encryption technology has also made them a favored communication tool for criminals and terrorist groups, including al Qaeda and the Islamic State.

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


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