CN ANYONE TELL ME ANSWR PLZ

Question

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

Answer 1

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.

Answer 2

SELECT name FROM students
WHERE university
IN ('MIT', 'Stanford', 'Harvard')
AND name='Jake';

Answer 3

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.

Answer 4

@Vukan This is SQL. The equals operator is simply an equals sign. Please don’t give false answers.

Answer 5

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

Answer 6

Answer from "SELECT name
... students... 5;
Answer is FORM and LIMIT.

Answer 7

In
And

Answer 8

UPDATE students
SET university='MIT'
WHERE id =682

Answer 9

I don't see any answer

Answer 10

UPDATE
students
SET university=' MIT
'WHERE id=682

Answer 11

SELECT name FROM students
WHERE university
IN ('MIT', 'Stanford', 'Harvard') AND name='Jake';

Answer 12

and name=='Jake'

Answer 13

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

Answer 14

If you need the answer, go back in the lesson and figure it out. You can also check the comments of the question.