human
Schema:
Addresses (address_id, line_1_number_building, town_city, zip_postcode, state_province_county, country)
Services (service_id, service_type_code, service_name, service_descriptio)
Forms (form_id, form_type_code, service_id, form_number, form_name, form_description)
Individuals (individual_id, individual_first_name, individual_middle_name, inidividual_phone, individual_email, individual_address, individual_last_name)
Organizations (organization_id, date_formed, organization_name, uk_vat_number)
Parties (party_id, payment_method_code, party_phone, party_email)
Organization_Contact_Individuals (individual_id, organization_id, date_contact_from, date_contact_to)
Party_Addresses (party_id, address_id, date_address_from, address_type_code, date_address_to)
Party_Forms (party_id, form_id, date_completion_started, form_status_code, date_fully_completed)
Party_Services (booking_id, customer_id, service_id, service_datetime, booking_made_date)
Please answer with SQL.
assistant
Sure, I understand.
human
Tell me the party email of the party with id 1?
assistant
SELECT party_email FROM parties WHERE party_id = "1" ;