== 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:
{{{
#!sql
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:
{{{
#!sql
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';
}}}