Objective: The objective of this assignment is to get you to practice running SQL queries

SQL

1- Construct an SQL query that will show the assignedID, professorName, and the professors home department for each professor that teaches a 2000 level course (all course codes that begin with a two)

2- Construct an SQL query that will show all the course IDs, lectureTimes, and Lecture durations for the Engineering department.

3- Business Development 3332 is no longer being taught by George (assignedID = 77), it is being taught by Royall (assignedID = 88). Update the course table to reflect this change.

4- In this imaginary university, they have a rule that states any professor cannot lecture for more than 6 hours per week. Construct an SQL query that will find any professor that is lecturing for more than 6 hours per week (please note the result set may be empty).

5- Bonus: write a PHP or Python DB-API script with an HTML5 frontend that will add a professor to the professors table.