from google.cloud import bigquery
def query_shakespeare():
    client = bigquery.Client.from_service_account_json('service_account.json')
    query_job = client.query("""
        SELECT corpus AS title, COUNT(*) AS unique_words
        FROM `bigquery-public-data.samples.shakespeare`
        GROUP BY title
        ORDER BY unique_words DESC
        LIMIT 10""")
    results = query_job.result()  # Waits for job to complete.
    for row in results:
              print("{}: {}".format(row.title, row.unique_words))
if __name__ == '__main__':
    query_shakespeare()