This lab uses the university database. Open the tabs and look for column names that two tables share.
- Every row of
takeswith the student's name: the student'sname, thecourse_id, then thegrade. UseUSING. - Think before you run it: how many rows does
student NATURAL JOIN takesreturn? - Think before you run it: how many rows does
student NATURAL JOIN takes NATURAL JOIN coursereturn? Run it to check. - Every row of
takeswith the student's name and the course title:name, thentitle. No row may be dropped. - Which column made the three-table natural join drop rows?