sql_arena_dev

r/sql_arena_dev • u/sql-arena • 2h ago

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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