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.
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.
Find customers who placed orders in consecutive calendar months.
Pivot a table of monthly_sales (month, year, total) to columns per month.
Use ROW_NUMBER to deduplicate orders, keeping the most recent per customer.
Find duplicate rows in an emails table based on email address.
Write a self-join to find pairs of employees with the same manager.
Calculate the percentage of total sales each product represents.
Use a CTE to find the longest chain of referrals in a referrals table.
Write a SQL query that returns customers with more than 3 orders.
Find the second-highest salary in an employees table.
Calculate the running total of sales by date using a window function.
Use a window function to rank orders within each customer.
Find products that have never been ordered using a left join.
Write a SQL query that returns the top 5 customers by total spend in 2025.
What is the least common multiple of 4, 6, and 9?
Convert 5 over 8 to a percentage.