SQL Question, don't use chatgpt to get the answer, which makes no sense. Thank you.

Imagine you had a table named 'students' with student information stored * 10 points in it. Which field is likely to be used as a foreign key within this table? id first_name last_name email city state country created * None of the above * Imagine further there was a second table named 'grades', which stored * 10 points students' grades on each assessment (quizzes, assignments, exams). Which query would show all students from the 'students' table and their grades on the final exam from the 'grades' table? The results must not include students who have not taken the final exam. SELECT first_name, last_name, grade FROM grades INNER JOIN students ON grades.id=students.student_id GROUP BY assessment_title="Final exam"; SELECT first_name, last_name, grade FROM grades LEFT JOIN students ON grades.id=students.student_id WHERE "final exam" INNER JOIN "assignment_title"=1; SELECT first_name, last_name, grade FROM students INNER JOIN grades ON students.id=grades.student_id WHERE assessment_title="final exam"; SELECT first_name, last_name, grade FROM students LEFT JOIN grades ON students.id=grades.student_id WHERE assessment_title="final exam"; Which SQL query would show each student's first and last names and the 10 points average score on their quizzes? SELECT first_name, last_name, AVG(grade) FROM students INNER JOIN grades ON students.id=grades.student_id WHERE assessment_type="quiz"; SELECT first_name, last_name, AVG(grade) FROM students INNER JOIN grades ON students.id=grades.student_id WHERE assessment_type="quiz" GROUP BY students.id; SELECT first_name, last_name, AVG(grade) FROM students INNER JOIN grades ON students.id=grades.student_id WHERE assessment_type="quiz" ORDER BY assessment_type; SELECT first_name, last_name, AVG(grade) FROM students LEFT JOIN grades ON students.id=grades.student_id WHERE assessment_type="quiz" ORDER BY assessment_type; Which SQL query would return just the names and grades of all students 10 points who have scored above a 90 on the midterm exam. SELECT last_name, first_name, grade FROM students INNER JOIN grades ON students.id=grades.student_id WHERE grade >90; SELECT last_name, first_name, grade FROM students INNER JOIN grades ON students.id=grades.student_id WHERE grade > 90 AND assessment_title="midterm exam"; SELECT last_name, first_name, grade FROM students LEFT JOIN grades ON grade > 90 AND grades.assessment_title="midterm exam"; SELECT last_name, first_name, grade FROM students LEFT JOIN grades ON students.id IS NULL AND grade > 90;; Which SQL query would return just the names of students who have NOT 10 points taken any assessments? SELECT first_name, last_name FROM students INNER JOIN grades ON students.id=grades.student_id WHERE grades.id IS NULL; SELECT first_name, last_name FROM students LEFT JOIN grades ON students.id=grades.student_id WHERE grades.id IS NULL; Which SQL query would return the average score on each of the different 10p assessments? SELECT assessment_title, AVG(grade) FROM students INNER JOIN grades ON students.id=grades.student_id; SELECT assessment_title, AVG(grade) FROM students INNER JOIN grades ON students.id=grades.student_id GROUP BY assessment_title; SELECT assessment_title, AVG(grade) FROM students INNER JOIN grades ON students.id=grades.student_id GROUP BY assessment_type;; SELECT assessment_type, AVG(grade) FROM students LEFT JOIN grades ON students.first_name=grades.first_name