Advanced Practice Problems - Mixed-up Code

Let’s practice what we have learned about SQL.

In addition to the grades table:

https://i.ibb.co/r6qShy5/practice-grade.png

there is also a students table:

https://i.ibb.co/m4KxSMC/practice-students.png

Create a SELECT statement with a JOIN to: select the test_name and math from the grades table and name from the students table, where the student_id in the grades table is the same as the id in the students table.

In addition to the grades table:

https://i.ibb.co/r6qShy5/practice-grade.png

there is also a students table:

https://i.ibb.co/KVTGNXh/practice-tests.png

Create a SELECT statement with a JOIN to: select the date and name from the tests table and student_id from the grades table, where the test_name in the grades table is the same as the name in the tests table.

You have attempted of activities on this page