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.

#59009 May 26

Use HAVING to filter aggregate results: orders with more than 5 line items.

V1BetterV2ΔLcsharp
#58909 May 26

Write a SQL query joining 4 tables (customers, orders, line_items, products) to produce a customer-order-product report.

V1BetterV2ΔLcsharp
#58809 May 26

Find products in the top 10 percent by revenue using NTILE.

V1BetterV2ΔLcsharp
#58709 May 26

Calculate the gap in days between consecutive logins per user using LAG.

V1BetterV2ΔLcsharp
#58609 May 26

Use EXISTS to find customers with at least one cancelled order.

V1BetterV2ΔLcsharp
#58509 May 26

Find the median salary in each department using window functions.

V1BetterV2ΔLcsharp
#58409 May 26

Write a recursive CTE to walk an employee-manager hierarchy from any starting employee.

V1BetterV2ΔLcsharp
#58309 May 26

Use UNION to combine current_employees and former_employees, marking source.

V1BetterV2ΔLcsharp
#58209 May 26

Find orders where the order_date is later than the ship_date.

V1BetterV2ΔLcsharp
#58109 May 26

Write a SQL query that returns products and their cumulative sales over time.

V1BetterV2ΔLcsharp
#58009 May 26

Calculate a moving 7-day average of daily_sales using a window function.

V1BetterV2ΔLcsharp
#57909 May 26

Find customers who placed orders in consecutive calendar months.

V1BetterV2ΔLcsharp
#57809 May 26

Pivot a table of monthly_sales (month, year, total) to columns per month.

V1BetterV2ΔLcsharp
#57709 May 26

Use ROW_NUMBER to deduplicate orders, keeping the most recent per customer.

V1BetterV2ΔL+0.5csharp
#57609 May 26

Find duplicate rows in an emails table based on email address.

V1BetterV2ΔL+0.5csharp
#57509 May 26

Write a self-join to find pairs of employees with the same manager.

V1BetterV2ΔLcsharp
#57409 May 26

Calculate the percentage of total sales each product represents.

V1BetterV2ΔLcsharp
#57309 May 26

Use a CTE to find the longest chain of referrals in a referrals table.

V1BetterV2ΔLcsharp
#57209 May 26

Write a SQL query that returns customers with more than 3 orders.

V1BetterV2ΔLcsharp
#57109 May 26

Find the second-highest salary in an employees table.

V1BetterV2ΔLcsharp
#57009 May 26

Calculate the running total of sales by date using a window function.

V1BetterV2ΔLcsharp
#56909 May 26

Use a window function to rank orders within each customer.

V1BetterV2ΔLcsharp
#56809 May 26

Find products that have never been ordered using a left join.

V1BetterV2ΔLcsharp
#56709 May 26

Write a SQL query that returns the top 5 customers by total spend in 2025.

V1BetterV2ΔLcsharp