WEEK 9 ASSIGNMENT#3 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 idcourse idsemesteryearJoin 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.

The answer is written in step 2

Answered: Part I: Complete the following…

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 2HOA: Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The...

See similar textbooks

Related questions

Concept explainers

Question

WEEK 9 ASSIGNMENT#3

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.
1. student id
2. course id
3. semester
4. 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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions