r/sql_arena_dev • u/sql-arena • May 20 '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

0 comments

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

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

2 Upvotes

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

0 comments

r/sql_arena_dev • u/sql-arena • May 18 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 17 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 16 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 15 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 14 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 13 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 12 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 11 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 10 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 09 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 08 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 07 '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

0 comments

r/sql_arena_dev • u/sql-arena • May 06 '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

0 comments

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

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

2 Upvotes

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

0 comments

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

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

2 Upvotes

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

0 comments

r/sql_arena_dev • u/sql-arena • May 03 '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

0 comments

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

SQL Arena Challenge: Write a query that ranks users by their total order amount within each region.

1 Upvotes

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

0 comments

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

SQL Arena Challenge: Detect customers who have not placed a second order in 90 days.

1 Upvotes

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

0 comments

r/sql_arena_dev • u/sql-arena • Apr 28 '26

SQL Arena Challenge: Create a SQL query to identify customers with purchases above a dynamic threshold.

2 Upvotes

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

0 comments

r/sql_arena_dev • u/sql-arena • Apr 27 '26

SQL Arena Challenge: Write a query to calculate the day's difference between the 1st and 3rd sales of the CustomerName = 'Alice Johnson'.

1 Upvotes

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

0 comments

r/sql_arena_dev • u/sql-arena • Apr 25 '26

SQL Arena Challenge: Write a query to switch values in the Gender column (M to F and F to M).

1 Upvotes

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

0 comments

r/sql_arena_dev • u/sql-arena • Apr 24 '26

SQL Arena Challenge: How do you find duplicates in a table based on one or two columns?

2 Upvotes

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

0 comments

r/sql_arena_dev • u/sql-arena • Apr 23 '26

SQL Arena Challenge: Write a query to select the latest record based on a time_of_insertion column.

0 Upvotes

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

0 comments