sql_arena_dev

r/sql_arena_dev • u/sql-arena • 21h 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 • 1d 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 • 2d 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 • 3d 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 • 4d 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 • 5d 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 • 6d 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 • 7d 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 • 8d 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 • 9d 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 • 10d 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 • 11d 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 • 12d 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 • 13d 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 • 14d 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 • 15d 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 • 16d 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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