what is the daily hire cost of the product id 1
select daily_hire_cost from products_for_hire where product_id = 1
what is the status date of the product name Book collection C ?
select status_date from view_product_availability as t1 join products_for_hire as t2 on t1.product_id = t2.product_id where product_name = "Book collection C"
what is the product description of the product id 3 ?
select product_description from products_for_hire where product_id = 3
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