import sqlite3
import pandas as pd

conn = sqlite3.connect("database (3).sqlite")
if conn:
    print("database connected")
else:
    print("database not connected")

pd.read_sql_query("""SELECT * FROM sqlite_master WHERE type='table';
""", conn)

matches = pd.read_sql_query("""SELECT * FROM Match;""", conn)
matches.head()

pd.read_sql_query("""SELECT AVG(Win_Margin), Match_Winner FROM Match 
WHERE Season_Id=9 GROUP BY Match_Winner ORDER BY AVG(Win_Margin) 
DESC;""", conn)

pd.read_sql_query("""SELECT COUNT(DISTINCT Venue_Id) FROM Match
WHERE Season_Id=9 ;""", conn)

pd.read_sql_query("""SELECT MIN(Win_Margin), MAX(Win_Margin),
AVG(Win_Margin) FROM MATCH;""", conn)

pd.read_sql_query("""SELECT SUM(Win_Margin) FROM Match;
""", conn)

pd.read_sql_query("""SELECT SUM(Win_Margin) FROM Match WHERE Season_Id=9;
""", conn)