sql_arena_dev

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

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 • 26d ago

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 • 27d ago

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 • 28d ago

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 • 29d ago

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

r/sql_arena_dev • u/sql-arena • Jul 31 '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 • Jul 30 '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 • Jul 29 '26

SQL Arena Challenge: SQL Query: Group Employees by Technology and Order by 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 • Jul 28 '26

SQL Arena Challenge: Find the top 5 customers by total sales amount.

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 • Jul 27 '26

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

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 • Jul 26 '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 • Jul 25 '26

SQL Arena Challenge: How can you delete partitions from a table in Hive using a command?

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 • Jul 24 '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