CREATE TABLE products_for_hire (product_name VARCHAR, product_id VARCHAR)
CREATE TABLE view_product_availability (product_id VARCHAR, available_yn VARCHAR)

What are the names of products whose availability equals to 1?
SELECT T2.product_name FROM view_product_availability AS T1 JOIN products_for_hire AS T2 ON T1.product_id = T2.product_id WHERE T1.available_yn = 1
SELECT "T2"."product_name" FROM "view_product_availability" AS "T1" JOIN "products_for_hire" AS "T2" ON "T1"."product_id" = "T2"."product_id" WHERE "T1"."available_yn" = 1