Define a function to execute the first query

def query1(): query = 'SELECT corderNo, dorderdate, s.cshopperId,vFirstName, mTotalCost FROM Shopper AS s, Orders AS a WHERE s.cShopperId=a.cShopperId AND mTotalCost>80;' # Execute the query using your database connection # Return the results (e.g. as a list of dictionaries)

Define a function to execute the second query

def query2(): query = 'SELECT cToyId, vToyName, category FROM Toys AS t, Category AS c WHERE t.cCategoryId=c.cCategoryId;' # Execute the query using your database connection # Return the results (e.g. as a list of dictionaries)

Define a function to execute the third query

def query3(): query = 'SELECT cToyId, VToyName,cBrandName FROM Toys AS t, ToyBrand AS tb WHERE t.cBrandId=tb.cBrandId;' # Execute the query using your database connection # Return the results (e.g. as a list of dictionaries)

Call the appropriate query function based on user input

query_choice = input('Which query do you want to execute? (1, 2, or 3)') if query_choice == '1': results = query1() elif query_choice == '2': results = query2() elif query_choice == '3': results = query3()

Print out the results

for result in results: print(result)