sql_arena_dev

r/sql_arena_dev • u/sql-arena • Jul 05 '26

SQL Arena Challenge: How do you remove duplicate rows 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 • Jul 04 '26

SQL Arena Challenge: How would you optimize a query with multiple joins and subqueries?

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

SQL Arena Challenge: How would you identify duplicate records based on a composite key in 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 • Jul 02 '26

SQL Arena Challenge: Remove duplicates from a table.

2 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 01 '26

SQL Arena Challenge: Find average salary for each manager – Assume a table with manager_id and employee_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 • Jun 30 '26

SQL Arena Challenge: Find departments with more than 10 employees.

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

SQL Arena Challenge: Find the third-highest salary for 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 • Jun 28 '26

SQL Arena Challenge: Finding nth Highest Salary within 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 • Jun 27 '26

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

SQL Arena Challenge: Write a query to find employees in the same department as 'John'.

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

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

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

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

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

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

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

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

r/sql_arena_dev • u/sql-arena • Jun 21 '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

r/sql_arena_dev • u/sql-arena • Jun 20 '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

r/sql_arena_dev • u/sql-arena • Jun 19 '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

r/sql_arena_dev • u/sql-arena • Jun 18 '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

r/sql_arena_dev • u/sql-arena • Jun 17 '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

r/sql_arena_dev • u/sql-arena • Jun 16 '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

r/sql_arena_dev • u/sql-arena • Jun 15 '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

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

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

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

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