import sqlite3 # Create a connection to the database conn = sqlite3.connect('Northwind2020.db') # Create a cursor object to execute SQL queries cursor = conn.cursor() # Retrieve the number of unique suppliers that have discontinued products query = ''' SELECT COUNT(DISTINCT SupplierId) FROM Product WHERE IsDiscontinued = 1 ''' cursor.execute(query) num_discontinued_suppliers = cursor.fetchone()[0] # Display an appropriate message based on the number of discontinued suppliers if num_discontinued_suppliers >= 20: print("20 or more suppliers have discontinued products.") elif num_discontinued_suppliers <= 0: print("All products are available.") else: print("Less than 20 suppliers have discontinued products.") # Close the database connection conn.close() import sqlite3 conn = sqlite3.connect('Northwind2020.db') SQL = '''SELECT COUNT(*)As NoMore FROM (SELECT Distinct(S.Id) FROM Supplier S, Product P WHERE S.Id == P.SupplierId AND P.IsDiscontinued = 1 GROUP BY S.CompanyName) ''' cursor = conn.cursor() cursor.execute(SQL) answer = cursor.fetchone() if answer[0]!= None: if int((answer[0]) >= 20): print("More than 20 suppliers have discontinued products.") else: print("Less than 20 suppliers have discontinued products.") else: print("All products are available.") cursor.close()