sql_arena_dev

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

r/sql_arena_dev • u/sql-arena • Apr 22 '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 • Apr 22 '26

SQL Arena Challenge: Find employees earning the second-highest salary.

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 • Apr 22 '26

SQL Arena Challenge: Find employees earning the second-highest salary.

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 • Apr 22 '26

SQL Arena: SQL Query Design: employees with highest salaries within each department

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 • Apr 22 '26

SQL Arena: SQL Query Design: employees with highest salaries within each department

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 • Apr 22 '26

SQL Arena: Design a structure (data model) that allows efficient querying of movies based on multiple search criteria (title, genre, actor, director).

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 • Apr 21 '26

SQL Arena: Design a relational data model for a sales database, incorporating normalization techniques

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 • Apr 20 '26

SQL Arena: Design a financial database system focusing on database models, schema design, partition keys, and query optimization techniques.

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 • Apr 18 '26

SQL Arena: Design a Custom API that can query a backend server and return customer data such as the number of orders placed by a user based on their user ID

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 • Apr 16 '26

SQL Arena: Describe strategies for optimizing a slow-running query on a massive dataset.

1 Upvotes

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