Write Sql Code Following Questions Use Inner Join Natural Join Join Tables Sections Enroll Q37040973

by

Write SQL code for the following questions

  • Use INNER JOIN (not NATURAL JOIN) to join tables Sections andEnrollments, list term, course number, sid, and grade. Note, the PKof Sections (consequently the FK in Enrollments) is composite. Whenjoining the two tables, the joining condition need to specify bothcolumns.
  • List term, course number, faculty name who teaches the class,sid, and grade for all enrollment records.
  • List the sid and last and first name of all students who havenot enrolled in any classes.

Solution

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.