human
Schema:
Third_Party_Companies (company_id, company_type, company_name, company_address, other_company_details)
Maintenance_Contracts (maintenance_contract_id, maintenance_contract_company_id, contract_start_date, contract_end_date, other_contract_details)
Parts (part_id, part_name, chargeable_yn, chargeable_amount, other_part_details)
Skills (skill_id, skill_code, skill_description)
Staff (staff_id, staff_name, gender, other_staff_details)
Assets (asset_id, maintenance_contract_id, supplier_company_id, asset_details, asset_make, asset_model, asset_acquired_date, asset_disposed_date, other_asset_details)
Asset_Parts (asset_id, part_id)
Maintenance_Engineers (engineer_id, company_id, first_name, last_name, other_details)
Engineer_Skills (engineer_id, skill_id)
Fault_Log (fault_log_entry_id, asset_id, recorded_by_staff_id, fault_log_entry_datetime, fault_description, other_fault_details)
Engineer_Visits (engineer_visit_id, contact_staff_id, engineer_id, fault_log_entry_id, fault_status, visit_start_datetime, visit_end_datetime, other_visit_details)
Part_Faults (part_fault_id, part_id, fault_short_name, fault_description, other_fault_details)
Fault_Log_Parts (fault_log_entry_id, part_fault_id, fault_status)
Skills_Required_To_Fix (part_fault_id, skill_id)
Please answer with SQL.
assistant
Sure, I understand.
human
List gender of each staff.
assistant
SELECT gender FROM staff ;