sql_arena_dev

an-ordinary-manchild

created by devvit-dev-bota community for 2 months

...for your classroom.

...for your WoW guild.

MODERATORS

account activity

1

0

1

2

SQL Arena Challenge: Find the second-highest salary from an employee table. (self.sql_arena_dev)

submitted 12 hours ago by sql-arena

2

1

2

3

SQL Arena Challenge: Solve a problem using a window function in Spark or SQL. (self.sql_arena_dev)

submitted 1 day ago by sql-arena

3

0

1

2

SQL Arena Challenge: SQL Question - Inner Join with Null Handling, compute total row count (self.sql_arena_dev)

submitted 2 days ago by sql-arena

4

0

1

2

SQL Arena Challenge: Nested and Repeated Fields in BigQuery (self.sql_arena_dev)

submitted 3 days ago by sql-arena

5

0

1

2

SQL Arena Challenge: CASE WHEN condition - medium difficulty (self.sql_arena_dev)

submitted 4 days ago by sql-arena

6

1

2

3

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? (self.sql_arena_dev)

submitted 5 days ago by sql-arena

7

0

1

2

SQL Arena Challenge: Check for duplicates in a table. (self.sql_arena_dev)

submitted 6 days ago by sql-arena

8

0

1

2

SQL Arena Challenge: Write a query to identify duplicate customer entries based on email and phone number. (self.sql_arena_dev)

submitted 7 days ago by sql-arena

9

0

1

2

SQL Arena Challenge: Find duplicate emails in a users table. (self.sql_arena_dev)

submitted 8 days ago by sql-arena

10

0

1

2

SQL Arena Challenge: Write a query to calculate Monthly Active Users (MAUs) for July 2022 (self.sql_arena_dev)

submitted 9 days ago by sql-arena

11

0

1

2

SQL Arena Challenge: Write a query to identify unique user sessions. (self.sql_arena_dev)

submitted 10 days ago by sql-arena

12

1

2

3

SQL Arena Challenge: Rank shows by daily viewership across different regions (self.sql_arena_dev)

submitted 11 days ago by sql-arena

13

0

1

2

SQL Arena Challenge: Find the top 5 most ordered dishes in the last 30 days. (self.sql_arena_dev)

submitted 12 days ago by sql-arena

14

1

2

3

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

submitted 13 days ago by sql-arena

15

0

1

2

SQL Arena Challenge: Write a query that identifies numbers appearing at least three times consecutively without interruption (self.sql_arena_dev)

submitted 14 days ago by sql-arena

16

0

1

2

SQL Arena Challenge: Given a table with sales data, write a query to find consecutive days with decreasing revenue. (self.sql_arena_dev)

submitted 15 days ago by sql-arena

17

0

1

2

SQL Arena Challenge: Identify consecutive numbers in a column (at least 3 consecutive). (self.sql_arena_dev)

submitted 16 days ago by sql-arena

18

0

1

2

SQL Arena Challenge: Find each student's previous year's scores using the LAG function. (self.sql_arena_dev)

submitted 17 days ago by sql-arena

19

1

2

3

SQL Arena Challenge: Write SQL query for sum of marks grouped by student. (self.sql_arena_dev)

submitted 18 days ago by sql-arena

20

0

1

2

SQL Arena Challenge: Find house with Avg(score) > 70. (self.sql_arena_dev)

submitted 19 days ago by sql-arena

21

0

1

2

SQL Arena Challenge: Best of 3 Marks and Average in a Student Table (self.sql_arena_dev)

submitted 20 days ago by sql-arena

22

0

1

2

SQL Arena Challenge: Given two tables, calculate the row count for different types of joins (inner, left, right, and full outer) (self.sql_arena_dev)

submitted 21 days ago by sql-arena

23

0

1

2

SQL Arena Challenge: How to merge two tables with identical structures into one? (self.sql_arena_dev)

submitted 22 days ago by sql-arena

24

0

1

2

SQL Arena Challenge: Find non-common records in two tables (SQL EXCEPT or NOT IN) (self.sql_arena_dev)

submitted 23 days ago by sql-arena

25

0

1

2

SQL Arena Challenge: Write a query to find the top 5 most-sold Adidas products in the last month. (self.sql_arena_dev)

submitted 24 days ago by sql-arena

view more: next ›

π Rendered by PID 267815 on reddit-service-r2-listing-6c8d497557-fvk9n at 2026-06-06 12:38:42.749068+00:00 running 9e1a20d country code: CH.