Year 11 SQL (Tasting lesson)

Which of the following is the correct SQL to output name, year and house of students from the table "Students"

Which of the following is the correct SQL to output all fields from table Students?

Which of the following is the correct SQL to output all fields of students from house 4?

Which of the following is the correct SQL to output the names of year 11 students from house 1

Which of the following is the correct SQL to output the names of students with name starting with "S"

Which of the followings is the correct SQL to output the names of students and their computer marks?

Which of the following is the correct SQL to output the names of students and their computer marks in ascending order of computer marks?

What is the possible problem if the table is defined as in the figure?

How many fields are there in the table "Marks"?

Which of the following should be filled in the SQL to output the students' names and their marks of Computer from the table "Students" and "Marks"?

SELECT Students.Name, Marks.Marks

FROM Students, Marks

WHERE _______________________________

Which of the following should be filled in the SQL to output the students’ names and their Media marks from the ‘Students’ and ‘Marks’ tables, in descending order of their names?

SELECT Students.Name, Marks.Marks

FROM Students, Marks

WHERE _______________________________