+ 2

CN ANYONE TELL ME ANSWR PLZ

Drag and drop from the options below to retrieve from MIT, Stanford, and Harvard the names of all students whose first name is Jake. SELECT name FROM students WHERE university ('MIT', 'Stanford', 'Harvard') name='Jake'; FROM IN BETWEEN OR AND

3rd Jan 2018, 1:24 AM
Akshara k
Akshara k - avatar
14 Respostas
+ 12
SELECT name FROM students WHERE university IN ('MIT', 'Stanford', 'Harvard') AND name='Jake'; IN operator allows you to specify a number of values and evaluate them as OR for the previous identifier. In this case, university can either be MIT, Stanford, or Harvard. AND operator evaluates if both LHS and RHS is true.
3rd Jan 2018, 2:35 AM
Hatsy Rei
Hatsy Rei - avatar
+ 3
SELECT name FROM students WHERE university IN ('MIT', 'Stanford', 'Harvard') AND name='Jake';
10th Apr 2018, 10:47 AM
Mahnoor Shahzad
Mahnoor Shahzad - avatar
+ 1
UPDATE students SET university='MIT' WHERE id =682 Drag and drop from the options below to update the "students" table to set Jake's university to MIT. His id is 682.
19th Dec 2019, 6:13 PM
Zobo
Zobo - avatar
0
@Vukan This is SQL. The equals operator is simply an equals sign. Please don’t give false answers.
3rd Jan 2018, 3:55 AM
Giancarlo Forero
0
Rearrange the code to select students from MIT and Stanford, and order the results by the ''university'' column. IN ('Stanford', 'MIT') SELECT name, university ORDER BY university; FROM students WHERE university
16th Sep 2018, 4:53 PM
Rishav Dev
Rishav Dev - avatar
0
Answer from "SELECT name ... students... 5; Answer is FORM and LIMIT.
7th Mar 2020, 12:38 AM
Imanuel Wicaksono
Imanuel Wicaksono - avatar
0
In And
22nd Apr 2020, 8:31 PM
Kashif Saleem
Kashif Saleem - avatar
0
UPDATE students SET university='MIT' WHERE id =682
4th Jun 2020, 8:57 AM
Yoan Ivanov
Yoan Ivanov - avatar
0
I don't see any answer
4th Jul 2020, 8:22 PM
Faith Mundi
Faith Mundi - avatar
0
UPDATE students SET university=' MIT 'WHERE id=682
11th Sep 2020, 8:13 PM
OjeifoIduma
0
SELECT name FROM students WHERE university IN ('MIT', 'Stanford', 'Harvard') AND name='Jake';
11th Sep 2020, 8:38 PM
OjeifoIduma
- 1
and name=='Jake'
3rd Jan 2018, 1:28 AM
Vukan
Vukan - avatar
- 1
Drag and drop from the options below to update the "students" table to set Jake's university to MIT. His id is 682. students SET university=' ' WHERE =682 name UPDATE Jake id MIT
18th Oct 2018, 10:10 AM
Airen Ranque
Airen Ranque - avatar
- 2
If you need the answer, go back in the lesson and figure it out. You can also check the comments of the question.
3rd Jan 2018, 1:34 AM
luciel
luciel - avatar