List the name of all products along with the number of complaints that they have received.
CREATE TABLE products (
    product_name VARCHAR,
    product_id VARCHAR
)

CREATE TABLE complaints (
    product_id VARCHAR
)
SELECT t1.product_name, COUNT(*) FROM products AS t1 JOIN complaints AS t2 ON t1.product_id = t2.product_id GROUP BY t1.product_name
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: List the name of all products along with the number of complaints that they have received. ### Input: CREATE TABLE products (
    product_name VARCHAR,
    product_id VARCHAR
)

CREATE TABLE complaints (
    product_id VARCHAR
) ### Response: SELECT t1.product_name, COUNT(*) FROM products AS t1 JOIN complaints AS t2 ON t1.product_id = t2.product_id GROUP BY t1.product_name