15)¶

SQL¶

Optional project¶

Music database

Note: The cumulative project grade will be computed as follows:

I will compute the average of the first seven projects (not including this one)
I will also compute the average of all eight project (including this one)
Then I will use the higher of the two averages.

Thus, your grade will not go down if you do not complete this project, but it may go up.

Resources¶

1. Gradebook SQLite database¶

gradebook_data.sqlite

2. Courses SQLite database¶

courses_data.sqlite

3. SQL with Python¶

Sample data:

[5]:

import pandas as pd

df = pd.DataFrame({'title': ['Casablanca', 'Forrest Gump', 'Goodfellas',
                              'Chinatown', 'Jaws', 'Wall-E'],
                   'director': ['M. Curtiz', 'R. Zemeckis', 'M. Scorsese',
                                 'R. Polanski', 'S. Spielberg', 'A. Stanton'],
                   'year': [1942, 1994, 1990, 1974, 1975, 2008]})