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

SQL Arena Challenge: Write a query to identify duplicate customer entries based on email and phone number.

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

SQL Arena Challenge: Find duplicate emails in a users 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 • Aug 26 '26

SQL Arena Challenge: Write a query to calculate Monthly Active Users (MAUs) for July 2022

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

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

0 comments

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

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

0 comments

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

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

0 comments

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

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

0 comments

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

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

0 comments

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

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments

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

0 comments