Какой из запросов покажет имена студентов у которых основной предмет (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;
Какой из запросов покажет имена студентов у которых основной предмет (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
With the help of the Search Filters option, users can now filter search results by type. They can do that by using the new tabs: Media, Links, Files and others. Searches can be done based on the particular time period like by typing in the date or even “Yesterday”. If users type in the name of a person, group, channel or bot, an extra filter will be applied to the searches.
How to Use Bitcoin?
n the U.S. people generally use Bitcoin as an alternative investment, helping diversify a portfolio apart from stocks and bonds. You can also use Bitcoin to make purchases, but the number of vendors that accept the cryptocurrency is still limited. Big companies that accept Bitcoin include Overstock, AT&T and Twitch. You may also find that some small local retailers or certain websites take Bitcoin, but you’ll have to do some digging. That said, PayPal has announced that it will enable cryptocurrency as a funding source for purchases this year, financing purchases by automatically converting crypto holdings to fiat currency for users. “They have 346 million users and they’re connected to 26 million merchants,” says Spencer Montgomery, founder of Uinta Crypto Consulting. “It’s huge.”
