Write a query to identify top-performing service technicians based on historical job data at ServiceTitan. Include only technicians with at least two completed jobs, and rank them by total completed job revenue.
Output
- One row per technician in the top three ranking positions, including ties
- Columns:
technician_name, completed_jobs, total_revenue, average_rating, and performance_rank
- Sort by
performance_rank ascending, then technician_name ascending
Output details
- Treat jobs with status exactly
completed as completed jobs.
- Rank technicians by
total_revenue descending.
- Round
average_rating to two decimal places.
- Assign tied technicians the same rank, with subsequent ranks skipped.