Web Scraping With SQL and Debugging | Dataford Interview Questions

Describe a time you used web scraping with SQL and debugging to deliver a data result.

Use the tables below to identify which scraped records were successfully matched to reference data and which were rejected during validation. Return only the final deliverable rows.

Output

One row per scraped page that passed validation and matched a known source
Columns: page_url, source_name, scraped_title, normalized_title, validation_status
Include only rows where the page was scraped successfully and the source is active
Sort by source_name, then page_url

Schema

scraped_pages

Column	Type	Description
page_idPK	INT	Primary key for the scraped page
source_id	INT	Reference to the source site
page_url	VARCHAR(255)	Scraped page URL
scraped_title	VARCHAR(255)	Title captured by the scraper
scrape_status	VARCHAR(20)	Scrape outcome such as success or failed

reference_sources

Column	Type	Description
source_idPK	INT	Primary key for the source
source_name	VARCHAR(255)	Human-readable source name
is_active	BOOLEAN	Whether the source is currently active

title_validations

Column	Type	Description
validation_idPK	INT	Primary key for the validation record
page_url	VARCHAR(255)	Validated page URL
normalized_title	VARCHAR(255)	Cleaned title after debugging and normalization
validation_flag	VARCHAR(20)	Validation outcome

Your question is Web Scraping With SQL and Debugging. 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