rdbms = 'oracle mysql postgresql'.split()
ultimate_database = rdbms[-1]
print("We love %s!" % ultimate_database)

%load_ext sql
%sql postgresql://will:longliveliz@localhost/shakes

%sql SELECT * FROM work LIMIT 2

result = _

result

result[0]

result[0][0]

result.keys

result[0]['longtitle']

result = %sql SELECT workid, title FROM work WHERE title ILIKE '%as%'

result

play_name = 'Tempest'

%%sql 
SELECT  
        c.charname,
        c.description,
        c.speechcount
FROM    work w
JOIN    character_work cw ON (w.workid = cw.workid)
JOIN    character c ON (cw.charid = c.charid)
WHERE   w.title = :play_name
AND     c.description != 'presented by spirits'

result = _

import pandas as pd
dataframe = pd.DataFrame(result, columns=result.keys)
dataframe

%matplotlib inline

import matplotlib.pyplot as plt

plt.pie(dataframe.speechcount, labels=dataframe.charname)