import sqlite3
# Please edit the path correctly.
connection = sqlite3.connect('final2023.db')
query = """
SELECT
pillarName,
AVG(positive_title) AS fraction_positive_titles
FROM
guardian
GROUP BY
pillarName;
"""
cursor = connection.cursor()
print(cursor.execute(query).fetchall())
connection.close()
sssssss