Access and manipulate the data $(40$ pts$)$

$1.$ Create an SQL file to do hold the queries you would write to solve the following

problems.

INFO $2630$: review assignment $3$

Revised: Spring $2020/21$

$$ Make sure to include a comment block at the top of the file including your name,

the assignment and course

$$ Remember, your file can contain multiple SQL statements so long as you end

each statement with a semicolon $($;$).$

$2.$ Write and test queries to solve each of the following problems. When you have a

successful query, make sure to copy your SQL statement into your SQL file.

$1)$ Find out what courses Patty Melt and Bilbo Baggins have taken or are taking.

Make sure to include the students$$ full name, class name, department, number,

section as well as the students$$ grades.

$2)$ Luke Skywalker enrolled in INFO $2430.$ Insert the needed entry to track this

enrollment.

$3)$ A new student, Rory Williams, has decided to enroll in courses. Make sure his

student record gets inserted. His phone number is $236-887-4061.$

$4)$ Find Rory$$s assigned stu$\_$id$.$

$5)$ Enroll Rory in the classes, INFO $1325$ and RING $1001$ by inserting to the enroll

table.

$6)$ Charlie Kelly has decided to drop INFO $2630$ and go into business with his

friends. Please delete his enrollment. Be careful to preserve any other earned

credit!

$7)$ Luke Skywalker earned a B in INFO $2430.$ Update the appropriate record to store

this grade.

$8)$ Find out if we need to close any courses due to low enrollment. Which classes

don$$t have any students enrolled in them? Make sure to include the course

name, department, number and section.

$9)$ Get a count of how many classes each student is currently taking.

Hint! Current classes are those without a final grade recorded in the enroll tableTask $3$: Insert sample data $(30$ pts$)$

Using the images below, add insert statements to your create.sql file.

classes:

enroll:

students:

Execute your insert statements on your recently created school database to test them.

If you encounter any errors, address the issue and run the script again.

Task $4$: Access and manipulate the data $(40pts)$

Create an SQL file to do hold the queries you would write to solve the following

problems.