Interview Guides
You are given candidate assessment results from the Micro1 talent platform. Write a PostgreSQL query that returns each candidate's score and rank within their specific technical domain. Use a window function so ranking resets for each domain, and sort the final output by domain name and rank. If two candidates have the same score in the same domain, break ties by earlier assessment date, then by lower candidate ID.
