Two-Metric Leaderboard with Filters

I need a compact leaderboard module that shows two key metrics—score and completion time—for every user. Viewers must be able to switch between an overall ranking and a by-category ranking, and they should also be able to filter results to display only today’s data. Your part is to handle the data layer and the core logic. The code should pull fresh figures from my existing database, calculate the rankings on the fly, and expose the results through a clean, well-documented endpoint (or set of queries) that I can plug straight into the front end. Deliverables • Queries or stored procedures that compute score and completion-time rankings • An endpoint or callable function returning overall or category ranks, with a “date=today” filter • Concise setup notes so I can drop everything into production Acceptance criteria • For any day, calling the endpoint without extra parameters returns the overall list sorted by score, then completion time • Supplying &view=category returns rankings confined to the requested category • Average response time under one second on a dataset of 100 k rows Keep the implementation straightforward, readable, and open to future additions such as weekly or monthly filters.

Project ID: 40391033