jeopardy_category_clues.DONE.py

import sqlite3

connection = sqlite3.connect('jeopardy.db')
cursor = connection.cursor()

cursor.execute("SELECT id, name FROM category ORDER BY RANDOM() LIMIT 1")
results = cursor.fetchall()
category_id, name = results[0]
print name

query = """SELECT value, text FROM clue
WHERE category=%s ORDER BY value""" % (category_id,)
cursor.execute(query)
results = cursor.fetchall()

for result in results:
    value, text = result
    print "[$%s] %s" % (value, text)