CREATE TABLE customers (customer_id NUMBER, customer_name CLOB)
CREATE TABLE settlements (settlement_id NUMBER, claim_id NUMBER, effective_date TIME, settlement_amount NUMBER)
CREATE TABLE services (service_id NUMBER, service_name CLOB)
CREATE TABLE customers_policies (customer_id NUMBER, policy_id NUMBER, date_opened TIME, date_closed TIME)
CREATE TABLE first_notification_of_loss (fnol_id NUMBER, customer_id NUMBER, policy_id NUMBER, service_id NUMBER)
CREATE TABLE available_policies (policy_id NUMBER, policy_type_code CLOB, customer_phone CLOB)
CREATE TABLE claims (claim_id NUMBER, fnol_id NUMBER, effective_date TIME)

Which policy type has the most records in the database?
SELECT policy_type_code FROM available_policies GROUP BY policy_type_code ORDER BY COUNT(*) DESC LIMIT 1
SELECT "policy_type_code" FROM "available_policies" GROUP BY "policy_type_code" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY