Reference no: EM133218340

This assignment contains two parts. You must complete Part I before moving on to Part II.

Part I:

Complete the following exercise:

Create the following table with the correct columns. Call your new table: student_course (see below). Populate this table with four rows. Make sure the student id column contains values that are also in the student id column of your student table.

student id
course id
semester
year

Join the student and student_course table where the student id values are the same.

Join the student and student_course table where the student id values are the same and year is equal to 2020.

Create a select statement that will return the length of the last name column by joining the student and student_course table where the student id values are the same and enroll month is June.

Once you have completed your assignment, copy and paste the script into a Word document.

Part II:

Complete the following exercise:

Using a subquery, select student first name where the student is in the student course table.

Using a subquery, select the course id where the average GPA is 2.

Using a subquery, select the course id where the average GPA is greater than 2.

Using a subquery, select student first name where the student is not in the student course table.

Once you have completed your assignment, copy and paste the script into the same Word document you used for Part I and submit it.