CREATE TABLE Parties_in_Events (Party_ID NUMBER, Event_ID NUMBER, Role_Code CHAR)
CREATE TABLE Parties (Party_ID NUMBER, Party_Details VARCHAR2)
CREATE TABLE Finances (Finance_ID NUMBER, Other_Details VARCHAR2)
CREATE TABLE Locations (Location_ID NUMBER, Other_Details VARCHAR2)
CREATE TABLE Channels (Channel_ID NUMBER, Other_Details VARCHAR2)
CREATE TABLE Products (Product_ID NUMBER, Product_Type_Code CHAR, Product_Name VARCHAR2, Product_Price NUMBER)
CREATE TABLE Agreements (Document_ID NUMBER, Event_ID NUMBER)
CREATE TABLE Events (Event_ID NUMBER, Address_ID NUMBER, Channel_ID NUMBER, Event_Type_Code CHAR, Finance_ID NUMBER, Location_ID NUMBER)
CREATE TABLE Assets (Asset_ID NUMBER, Other_Details VARCHAR2)
CREATE TABLE Products_in_Events (Product_in_Event_ID NUMBER, Event_ID NUMBER, Product_ID NUMBER)
CREATE TABLE Addresses (Address_ID NUMBER, address_details VARCHAR2)
CREATE TABLE Assets_in_Events (Asset_ID NUMBER, Event_ID NUMBER)

Show the names of products and the number of events they are in. Visualize by bar chart.
SELECT Product_Name, COUNT(*) FROM Products AS T1 JOIN Products_in_Events AS T2 ON T1.Product_ID = T2.Product_ID GROUP BY T1.Product_Name
SELECT "Product_Name", COUNT(*) FROM "Products" "T1" JOIN "Products_in_Events" "T2" ON "T1"."Product_ID" = "T2"."Product_ID" GROUP BY "T1"."Product_Name"