Skip to contentSkip to footer

Data Analysts Interview Questions

Salaries
Interviews

49,345 data analysts 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 2311 - 2320 interview questions

Glassdoor has 49,345 interview questions and reports from Data analysts interviews. Prepare for your interview. Get hired. Love your job.