SQL and Database Questions | Dataford Interview Questions

Explain how you would approach medium-level LeetCode and database-related questions.

Use the provided tables to demonstrate a complete database solution that combines account, contact, and engagement information. Return only active accounts that meet the engagement threshold.

Output

One row per qualifying active account, with industry, company_name, total_score, engagement_count, engagement_status, and industry_rank.
Include accounts with at least 100 total engagement points during 2024, ranking ties equally within each industry.
Sort by industry ascending, industry_rank ascending, and company_name ascending.

Schema

accounts

Column	Type	Description
account_idPK	INT	Unique account identifier
company_name	VARCHAR(150)	Account company name
industry	VARCHAR(80)	Account industry
status	VARCHAR(20)	Account lifecycle status

contacts

Column	Type	Description
contact_idPK	INT	Unique contact identifier
account_id	INT	Associated account identifier
contact_name	VARCHAR(120)	Contact full name

engagements

Column	Type	Description
engagement_idPK	INT	Unique engagement identifier
contact_id	INT	Contact associated with the engagement
engagement_date	DATE	Date of engagement
score	INT	Points assigned to the engagement
channel	VARCHAR(40)	Engagement channel

Your question is SQL and Database Questions. 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