按年份统计电影数量

def solve():
    import sqlite3
    import pandas as pd
    conn = sqlite3.connect(':memory:')
    df = pd.read_csv('https://liangdaima.com/static/data/ds_movies.csv')
    df.to_sql('movies', conn, index=False)
    result = conn.execute('SELECT year, COUNT(*) AS cnt FROM movies GROUP BY year ORDER BY year').fetchall()
    conn.close()
    return result