SQL Joins for Web Traffic Data | Dataford Interview Questions

Question on web monthly traffic data with multiple tables. It required joining tables and fetching the traffic data based on some criteria. Coding questions were based on distributed servers with power of 2 load capability. Very similar to what other internship candidates have mentioned here.

Write a query for active pages belonging to North America sites during January and February 2025, retaining site-month totals of at least 1,000 visits.

Output

One row per qualifying site and month with site_name, month_start, total_visits, and page_count
Include only qualifying site-months, ordered by site_name, then month_start

Schema

sites

Column	Type	Description
site_idPK	INT	Unique site identifier
site_name	VARCHAR(100)	Name of the website
region	VARCHAR(50)	Geographic region assigned to the site

web_pages

Column	Type	Description
page_idPK	INT	Unique page identifier
site_id	INT	Site containing the page
page_name	VARCHAR(100)	Page label
is_active	BOOLEAN	Whether the page is currently active

monthly_traffic

Column	Type	Description
traffic_idPK	INT	Unique traffic record identifier
page_id	INT	Page receiving the traffic
month_start	DATE	First day of the traffic month
visits	INT	Number of recorded visits

Your question is SQL Joins for Web Traffic Data. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem