CREATE TABLE parties (party_id NUMBER, party_details CLOB)
CREATE TABLE parties_in_events (party_id NUMBER, event_id NUMBER, role_code CLOB)
CREATE TABLE events (event_id NUMBER, address_id NUMBER, channel_id NUMBER, event_type_code CLOB, finance_id NUMBER, location_id NUMBER)
CREATE TABLE products (product_id NUMBER, product_type_code CLOB, product_name CLOB, product_price NUMBER)
CREATE TABLE locations (location_id NUMBER, other_details CLOB)
CREATE TABLE assets (asset_id NUMBER, other_details CLOB)
CREATE TABLE agreements (document_id NUMBER, event_id NUMBER)
CREATE TABLE products_in_events (product_in_event_id NUMBER, event_id NUMBER, product_id NUMBER)
CREATE TABLE channels (channel_id NUMBER, other_details CLOB)
CREATE TABLE assets_in_events (asset_id NUMBER, event_id NUMBER)
CREATE TABLE finances (finance_id NUMBER, other_details CLOB)
CREATE TABLE addresses (address_id NUMBER, address_details CLOB)

Show the product type codes that have at least two products.
SELECT product_type_code FROM products GROUP BY product_type_code HAVING COUNT(*) >= 2
SELECT "product_type_code" FROM "products" GROUP BY "product_type_code" HAVING COUNT(*) >= 2