Use-case 0012 - Search for Sitters by Service

Initiating actor: Pet Owner

Other actors: None

Description: A Pet Owner needs a specific service and wants to find sitters who offer it. The system filters the registered sitters based on the service selected by the owner.

Scenario:

1. Pet Owner navigates to the "Find a Sitter" search page.
2. System fetches all available services to populate the search dropdown:

   SELECT type FROM services ORDER BY type ASC;
   

3. Owner selects "Dog Walking" from the dropdown and clicks "Search".
4. System joins the tables to find sitters who offer that exact service:

   SELECT u.user_id, u.first_name, u.last_name, u.email 
   FROM users u
   JOIN pet_sitters ps ON u.user_id = ps.user_id
   JOIN sitter_services ss ON ps.user_id = ss.sitter_id
   JOIN services s ON ss.service_id = s.service_id
   WHERE s.type = 'Dog Walking';