Skip to contentSkip to footer

Data Analyst Internship Interview Questions

Salaries
Interviews

47,103 data analyst internship interview questions shared by candidates

What is the following SQL code trying to do? Please explain (select A.RecipientID B.BeginDate, B.EndDate, B.CountyOfResidence, B.MajorProgram, B.EligibilityType, A.Birthdate, (Case When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 21 then 'Ages 0 through 21' When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 65 then 'Ages 22 through 65' When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 65 then 'Ages 66 and Over' Else 'error' end_ as Age_Category from dhsviews.Recipients V as A, DHSViews.RecipientElibgibility V as B Where A.RecipientID = B.RecipientID and B.MajorProgram IN ('MA', 'NM', 'IM', 'EH') and B.EligibilityStatus IN('A', 'C') and B.BeginDate <= date '2010-12-31' and B.EndDate >= date '2010-01-01' Order by 1,2);
avatar

Health Data Analyst

Interviewed at State of Minnesota

3.9★
Apr 15, 2020

What is the following SQL code trying to do? Please explain (select A.RecipientID B.BeginDate, B.EndDate, B.CountyOfResidence, B.MajorProgram, B.EligibilityType, A.Birthdate, (Case When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 21 then 'Ages 0 through 21' When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 65 then 'Ages 22 through 65' When ((date'2010-12-31' - dhsviews.RecipientsV.Birthdate ) / 365.25) <= 65 then 'Ages 66 and Over' Else 'error' end_ as Age_Category from dhsviews.Recipients V as A, DHSViews.RecipientElibgibility V as B Where A.RecipientID = B.RecipientID and B.MajorProgram IN ('MA', 'NM', 'IM', 'EH') and B.EligibilityStatus IN('A', 'C') and B.BeginDate <= date '2010-12-31' and B.EndDate >= date '2010-01-01' Order by 1,2);

Initial Phone Screen/ Behavioral: Describe a challenging project. Tell me about yourself. Rate your SQL skills on a scale of 1-10 SQL Technical Assessment: 1) General time series question. 2) Compare Data 3) Pivot a table without Pivot Function 4) Cross Join Problem 5) Union with CTE (probably other ways to solve) 6) Self Join Problem 7)Requires Windows Function, either Rank or Row Number
avatar

Data Analyst

Interviewed at The Home Depot

3.7★
Nov 18, 2021

Initial Phone Screen/ Behavioral: Describe a challenging project. Tell me about yourself. Rate your SQL skills on a scale of 1-10 SQL Technical Assessment: 1) General time series question. 2) Compare Data 3) Pivot a table without Pivot Function 4) Cross Join Problem 5) Union with CTE (probably other ways to solve) 6) Self Join Problem 7)Requires Windows Function, either Rank or Row Number

Viewing 2201 - 2210 interview questions

Glassdoor has 47,103 interview questions and reports from Data analyst internship interviews. Prepare for your interview. Get hired. Love your job.