Required Problems

In this section, you are required to complete the problems below and submit your code to OJ website.

Remember, you can use ok to test your code:

$ python ok  # test all tables
$ python ok -q <table>  # test single table

You can also do your own experiments interactively:

$ python sqlite_shell.py --init lab11.sql

Or only starts with the original data in lab11_data.sql:

$ python sqlite_shell.py --init lab11_data.sql