con = psycopg2.connect(user=PostgreSQL_username, password=PostgreSQL_password,
                       host = PostgreSQL_host, port = PostgreSQL_port, database = "fakenews")
cur = con.cursor()

num_articles = ("SELECT COUNT(*) FROM Article;")
cur.execute(num_articles)
num = cur.fetchall()


dist_types = ("WITH Temp AS (SELECT type_name, Article.type_id FROM (Article JOIN Typ ON Article.type_id = Typ.type_id )) SELECT type_name, COUNT(type_name) FROM Temp GROUP BY type_name;")
cur.execute(dist_types)
dist = cur.fetchall()


x = "SELECT T.type_name, COUNT(A.article_id) FROM typ T, article A WHERE A.type_id = T.type_id AND NOT EXISTS (SELECT * FROM written_by W WHERE W.article_id = A.article_id) GROUP BY T.type_name"

cur.execute(x)
y = cur.fetchall()

cur.close()
con.close()