Top Industries for Non-STEM Engagement | Dataford Interview Questions

Given a schema representing employer postings and student applications, write a query to identify the top three industries attracting the most engagement from non-STEM majors.

Use employer_postings, students, and applications. Treat each application from a student whose major_category is Non-STEM as one engagement, and exclude postings without an industry.

Output

One row per industry with columns industry and engagement_count
Include the three highest counts, ordered descending by count, with alphabetical ordering for ties

Schema

employer_postings

Column	Type	Description
posting_idPK	INT	Unique identifier for an employer posting
employer_name	VARCHAR(100)	Name of the employer
industry	VARCHAR(100)	Industry associated with the posting

students

Column	Type	Description
student_idPK	INT	Unique identifier for a student
student_name	VARCHAR(100)	Student name
major_category	VARCHAR(50)	Broad classification of the student's major

applications

Column	Type	Description
application_idPK	INT	Unique identifier for an application
student_id	INT	Student who submitted the application
posting_id	INT	Posting receiving the application
applied_at	DATE	Date the application was submitted

Your question is Top Industries for Non-STEM Engagement. 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