What SQLPad changed

• The homepage practice question changed from counting Airbnb bookings to identifying top and bottom eCommerce products.
• A new "Hint" section was added to the demo, advising users to ask interviewers about handling "ties" in data.
• The sample dataset changed from travel/bookings to eCommerce sales.
• The official solution was updated to use CTEs (Common Table Expressions) and UNION ALL operators.
• The leaderboard scores were updated, with the top user's score increasing from 1043 to 1123 points.

The site replaced a simple date-joining exercise with a more complex revenue analysis problem. This suggests they are focusing on more advanced business logic and "Common Table Expressions" (CTEs) to better reflect modern data analyst interviews.

• The demo question changed from finding top/bottom selling products to calculating daily US bookings.
• The sample dataset shifted from a single "orders" table to three tables: "bookings," "dates," and "listings."
• The official solution now demonstrates more advanced concepts like Common Table Expressions (CTEs), INNER JOINs, and LEFT JOINs to handle missing data.
• The leaderboard updated with a slight score increase for the top-ranked user.

The site replaced its primary "try before you sign up" sample question. This suggests they are shifting focus from general e-commerce SQL problems to more complex, multi-table joins involving Airbnb-style marketplace data.

• The score for the #1 ranked user, Fabryce Gold, increased from 1022 pts to 1039 pts.

The leaderboard shows that users are actively practicing on the platform. A score increase for the top user indicates ongoing engagement and competition within the community.