5)
Rank order all students by total credit (DESC)
6)
Create a view tot_credits_dept
(columns: year, dept_name,
num_credits)
with the total
number of credits taken
by all students in each year for courses offered by each department
7)
Compute average
number of credits over three
preceding years
per department using the view you created
8)
Compute maximum
number of credits over for the window
of 2 years before and 2 years after the
current year per department
9)
Using the view you just created, get the average
total credits by each department over all prior years.
10)
See the last slide of lecture 10 (DB Connection with Python)
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.