Public viewer
The journey of every round
Every round-trip in the corpus is public. Open one to see the prompt, the zero-point index, the baseline response, the enhanced response, and how each grader read the difference. Leave a comment if a grader's reading lands — or doesn't.
Create an ApiController class with a single GET ActionResult that returns a product or NotFound when no product matches the route id.
Write an IMiddleware implementation that adds an X-Request-ID header to every response. Show it being registered in the request pipeline.
Write a custom equality comparer (IEqualityComparer<Person>) that treats two Person records as equal when Email lowercased matches. Include GetHashCode.
Write a Regex that matches IPv4 addresses in the form '1.2.3.4' (each octet 0–255). Use Regex.Match on a sample string.
Write a ReadOnlySpan<byte>-based UTF-8 BOM check: return true if the span starts with the bytes 0xEF 0xBB 0xBF.
Write a using-block over a StreamReader that reads each line and counts occurrences of the word 'foo'. No async.
Write a generic Swap<T> method that swaps two ref T parameters. Include an example call with two ints.
Implement a multitenant request-scoped ITenantInfo resolver that reads the tenant id from a custom header and falls back to subdomain.
Build a SignalR Hub that lets clients subscribe to a 'price-tick' channel and broadcasts ticks to all subscribers on a one-second timer.
Implement a generic repository for read-only access to entities by id using a DbContext. Include AsNoTracking and a CancellationToken parameter.
Write a BackgroundService that reads work items from an in-memory queue and processes each one with a small delay, with graceful shutdown handling.
Write an IMiddleware implementation that adds an X-Request-ID header to every response. Show it being registered in the request pipeline.
Find the date with the highest number of new signups in a users table.
Use HAVING to filter aggregate results: orders with more than 5 line items.
Write a SQL query joining 4 tables (customers, orders, line_items, products) to produce a customer-order-product report.
Find products in the top 10 percent by revenue using NTILE.
Calculate the gap in days between consecutive logins per user using LAG.
Use EXISTS to find customers with at least one cancelled order.
Find the median salary in each department using window functions.
Write a recursive CTE to walk an employee-manager hierarchy from any starting employee.
Use UNION to combine current_employees and former_employees, marking source.
Find orders where the order_date is later than the ship_date.
Write a SQL query that returns products and their cumulative sales over time.
Calculate a moving 7-day average of daily_sales using a window function.