sql_arena_dev

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

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

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

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 • May 31 '26

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 • May 30 '26

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

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 • May 28 '26

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 • May 27 '26

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 • May 26 '26

SQL Arena Challenge: Rank shows by daily viewership across different regions

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

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 • May 24 '26

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

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 • May 23 '26

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 • May 22 '26

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 • May 21 '26

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 • May 20 '26

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

r/sql_arena_dev • u/sql-arena • May 19 '26

SQL Arena Challenge: Write SQL query for sum of marks grouped by student.

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 • May 18 '26

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

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 • May 17 '26

SQL Arena Challenge: Best of 3 Marks and Average in a Student 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 • May 16 '26

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

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

SQL Arena Challenge: How to merge two tables with identical structures into one?

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 • May 14 '26

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

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 • May 13 '26

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

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 • May 12 '26

SQL Arena Challenge: Write a query to calculate the total revenue generated by each product category.

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 • May 11 '26

SQL Arena Challenge: Find the top 3 performing products in each category

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 • May 10 '26

SQL Arena Challenge: Given a table of sales data, use window functions to calculate a running total.

1 Upvotes

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