by Uwe Ricken | Jan 27, 2025 | Level 400, SQL Challenges
Problem Description / Requirement The customer operates a 45 TB data warehouse that is updated 24/7 with a frequence of 5 minutes. Partitioning is used on the biggest table to increase efficiency in loading processes. Before the loading starts the loading process must...
by Uwe Ricken | Jan 20, 2025 | Level 200, SQL Challenges
Problem Description / Requirement The marketing department of db Berater GmbH is planning a private event for its 10 TOP customers. The marketing department provides the following guidelines for selecting customers: Only customers with at least 3 orders in the last...
