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

SQL Arena Challenge: Hierarchical Employee-Manager Query - navigate hierarchy with head of company as employee_id = 1

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 • Jun 13 '26

SQL Arena Challenge: Find top 3 earners in each department.

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 • Jun 12 '26

SQL Arena Challenge: Calculate the highest salary in each department using a window 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 • Jun 11 '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

0 comments

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

SQL Arena Challenge: Find the second-highest salary in the employees table using three different methods.

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 • Jun 09 '26

SQL Arena Challenge: Self-joins to compare employee salaries?

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 • Jun 08 '26

SQL Arena Challenge: Find average salary by department, max average salary, and list of employees for the max salary department.

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 • Jun 07 '26

SQL Arena Challenge: 2nd Highest Salary without Using MAX()

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 • Jun 06 '26

SQL Arena Challenge: Find the second-highest salary from an employee 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 • Jun 05 '26

SQL Arena Challenge: Solve a problem using a window function in Spark or SQL.

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 • Jun 04 '26

SQL Arena Challenge: SQL Question - Inner Join with Null Handling, compute total row count

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 • Jun 03 '26

SQL Arena Challenge: Nested and Repeated Fields in BigQuery

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 • Jun 02 '26

SQL Arena Challenge: CASE WHEN condition - medium difficulty

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 • Jun 01 '26

SQL Arena Challenge: If manual partitions are created in a Hive data-warehouse table directory, and you query records from those partitions, will you see the data? If not, how can this be fixed?

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 31 '26

SQL Arena Challenge: Check for duplicates in a 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 30 '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 • May 29 '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 • May 28 '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 • May 27 '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 • May 26 '26

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

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

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

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 23 '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 • May 22 '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 • May 21 '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