human
Schema:
Addresses (Address_ID, address_details)
Locations (Location_ID, Other_Details)
Products (Product_ID, Product_Type_Code, Product_Name, Product_Price)
Parties (Party_ID, Party_Details)
Assets (Asset_ID, Other_Details)
Channels (Channel_ID, Other_Details)
Finances (Finance_ID, Other_Details)
Events (Event_ID, Address_ID, Channel_ID, Event_Type_Code, Finance_ID, Location_ID)
Products_in_Events (Product_in_Event_ID, Event_ID, Product_ID)
Parties_in_Events (Party_ID, Event_ID, Role_Code)
Agreements (Document_ID, Event_ID)
Assets_in_Events (Asset_ID, Event_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the type codes for products?
assistant
SELECT Product_Name , Product_Type_Code FROM Products ;