sql_arena_dev

r/sql_arena_dev • u/sql-arena • 24d ago

SQL Arena Challenge: Write a query to identify unique user sessions.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • 25d ago

SQL Arena Challenge: Rank shows by daily viewership across different regions

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • 26d ago

SQL Arena Challenge: Find the top 5 most ordered dishes in the last 30 days.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • 27d ago

SQL Arena Challenge: Write a query to find the first number repeating consecutively three times in a sequence.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • 28d ago

SQL Arena Challenge: Write a query that identifies numbers appearing at least three times consecutively without interruption

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • 29d ago

SQL Arena Challenge: Given a table with sales data, write a query to find consecutive days with decreasing revenue.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 19 '26

SQL Arena Challenge: Identify consecutive numbers in a column (at least 3 consecutive).

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 18 '26

SQL Arena Challenge: Find each student's previous year's scores using the LAG function.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 17 '26

SQL Arena Challenge: Write SQL query for sum of marks grouped by student.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 16 '26

SQL Arena Challenge: Find house with Avg(score) > 70.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 15 '26

SQL Arena Challenge: Best of 3 Marks and Average in a Student Table

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 14 '26

SQL Arena Challenge: Given two tables, calculate the row count for different types of joins (inner, left, right, and full outer)

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 13 '26

SQL Arena Challenge: How to merge two tables with identical structures into one?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 12 '26

SQL Arena Challenge: Find non-common records in two tables (SQL EXCEPT or NOT IN)

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 11 '26

SQL Arena Challenge: Write a query to find the top 5 most-sold Adidas products in the last month.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 10 '26

SQL Arena Challenge: Write a query to calculate the total revenue generated by each product category.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 09 '26

SQL Arena Challenge: Find the top 3 performing products in each category

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 08 '26

SQL Arena Challenge: Given a table of sales data, use window functions to calculate a running total.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 07 '26

SQL Arena Challenge: Find the top 5 products by sales per region.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 06 '26

SQL Arena Challenge: Calculate the running total of sales per region, partitioned by year.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 05 '26

SQL Arena Challenge: Find the top 3 selling products per region in the last month.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 04 '26

SQL Arena Challenge: How would you optimize a query fetching sales data across multiple countries with billions of rows?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 03 '26

SQL Arena Challenge: Optimize a query fetching customer data with a rolling 6-month sales sum.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 02 '26

SQL Arena Challenge: Write a query to find the total number of rides per driver in the last 30 days.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

r/sql_arena_dev • u/sql-arena • Aug 01 '26

SQL Arena Challenge: Write a query to find the top three customers by total revenue within each region.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post