import connect

    mydb = connect.getDB()
    mycursor = mydb.cursor()
    
    sql = "select wineSet.setID,wineSet.name, sum(price*quantity) from wineSet inner join setDetail using(setID) inner join wine using(wineID) group by setDetail.setID"
    mycursor.execute(sql)
        
    myresult = mycursor.fetchall()
        
    for x in myresult:
        print(x)
        
    mydb.close()