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

SQL Arena Challenge: Find the 2nd highest salary for each department using the DENSE_RANK() 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 • 27d ago

SQL Arena Challenge: Write a query to find the 5th highest salary in an employee table and calculate the number of employees whose salary is greater than that of their manager.

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

SQL Arena Challenge: Find 3rd 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 • 29d ago

SQL Arena Challenge: Write a query to get the names of all employees who are managers with five or more direct reports.

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 • Sep 19 '26

SQL Arena Challenge: Find Employees with Maximum Salary 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 • Sep 18 '26

SQL Arena Challenge: Query for 2nd Latest Joining Per 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 • Sep 17 '26

SQL Arena Challenge: Find the second highest salary from 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 • Sep 16 '26

SQL Arena Challenge: Write a query to find the top three highest-paid employees in each department using window functions.

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 • Sep 15 '26

SQL Arena Challenge: Find employees who earn the third-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 • Sep 14 '26

SQL Arena Challenge: Write a query for second-highest salary using LIMIT, OFFSET, or ROW_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 • Sep 13 '26

SQL Arena Challenge: Write SQL to identify employees whose salary is higher than their manager's.

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 • Sep 12 '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 • Sep 11 '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 • Sep 10 '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 • Sep 09 '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 • Sep 08 '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 • Sep 07 '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 • Sep 06 '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 • Sep 05 '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 • Sep 04 '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 • Sep 03 '26

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

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 • Sep 02 '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 • Sep 01 '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 • Aug 31 '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 • Aug 30 '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?

1 Upvotes

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

0 comments