4. Pinterest's Popular Boards

Interview Core Track · Easy · 15 min

Pinterest users can create and share content in the form of personal "boards". Each board is categorized under a specific theme, such as "Home Decor" or "Tra...

Interview Core Track

Easy

15 min

joins

filtering

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice joins through a Pinterest-tagged business scenario.

Approach

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

Pinterest users can create and share content in the form of personal "boards". Each board is categorized under a specific theme, such as "Home Decor" or "Travel". **Write a SQL query to find the top 3 most popular boards in the "Home Decor" category.** users **Example Input:** user_id username ------------------- 101 'jane_doe' 102 'john_doe' 103 'doe_rayme' boards **Example Input:** board_id user_id category followers_count ------------------------------------------------- 2001 101 'Home Decor' 500 2002 102 'Travel' 800 2003 101 'Cooking' 300 2004 103 'Home Decor' 1000 2005 102 'Home Decor' 700 **Answer:** SELECT username, board_id, followers_count FROM boards b JOIN users u USING(user_id) WHERE category = 'Home Decor' ORDER BY 3 DESC LIMIT 3 ---

users

user_id INT PRIMARY KEY

username VARCHAR(50

boards

board_id INT PRIMARY KEY

user_id INT REFERENCES users(user_id

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.