What are the start date and end date of the booking that has booked the product named 'Book collection A'?
create table bookings (booking_start_date varchar, booking_end_date varchar, booking_id varchar, PRIMARY KEY (booking_start_date)); create table products_booked (product_id varchar, booking_id varchar, PRIMARY KEY (product_id)); create table products_for_hire (product_id varchar, product_name varchar, PRIMARY KEY (product_id))
select t3.booking_start_date, t3.booking_end_date from products_for_hire as t1 join products_booked as t2 on t1.product_id = t2.product_id join bookings as t3 on t2.booking_id = t3.booking_id where t1.product_name = 'book collection a'