CREATE TABLE product (product_id NUMBER, product_name CLOB, product_details CLOB)
CREATE TABLE problems (problem_id NUMBER, product_id NUMBER, closure_authorised_by_staff_id NUMBER, reported_by_staff_id NUMBER, date_problem_reported TIME, date_problem_closed TIME, problem_description CLOB, other_problem_details CLOB)
CREATE TABLE staff (staff_id NUMBER, staff_first_name CLOB, staff_last_name CLOB, other_staff_details CLOB)
CREATE TABLE problem_status_codes (problem_status_code CLOB, problem_status_description CLOB)
CREATE TABLE problem_category_codes (problem_category_code CLOB, problem_category_description CLOB)
CREATE TABLE problem_log (problem_log_id NUMBER, assigned_to_staff_id NUMBER, problem_id NUMBER, problem_category_code CLOB, problem_status_code CLOB, log_entry_date TIME, log_entry_description CLOB, log_entry_fix CLOB, other_log_details CLOB)

Find the top 3 products which have the largest number of problems?
SELECT T2.product_name FROM problems AS T1 JOIN product AS T2 ON T1.product_id = T2.product_id GROUP BY T2.product_name ORDER BY COUNT(*) DESC LIMIT 3
SELECT "T2"."product_name" FROM "problems" "T1" JOIN "product" "T2" ON "T1"."product_id" = "T2"."product_id" GROUP BY "T2"."product_name" ORDER BY COUNT(*) DESC FETCH FIRST 3 ROWS ONLY