What booking made date of service id 1?
SELECT booking_made_date FROM services AS t1 JOIN party_services AS t2 ON t1.service_id   =   t2.service_id where t1.service_id   =  "1"
booking made date refers to booking_made_date; service id refers to service_id; JOIN is used to combine rows from two or more tables based on a related column between them.