Your assignment involves combining information from a number of SQL tables,

then displaying the information in a pandas DataFrame.

For your relational database management system, you may use any RDBMS$,$

including MySQL$,$ PostgreSQL, sqlite, or any of the other RDMBSs supported by

the database in Step $1$ below.

For your database, you should download and install the appropriate version

of the Chinook database for your RDBMS$,$ which is available here, under the

downloads tab:

Your task is to create a pandas DataFrame that displays Customers' Last

Name and First Name, and each customer's purchased Track names and

Album Titles. The information should be sorted by Customer LastName

then Customer FirstName. The first five rows of your results should look

like this:

information to use: chinook$-$database$/$ChinookDatabase$/$DataSources$/$Chinook$\_$Sqlite.sqlite at master $$ lerocha$/$chinook$-$database $$ GitHub

Sample database: Chinook sample database