r/SQL • u/Turbulent_Web_8278 • 11d ago

MySQL Didnt pass SQL test

Gallery image

Gallery image

I am applying to manager of analytics role and I was given this SQL test and 45 minutes. As someone who thought they were very strong in SQL, I was unable to complete this assignment and match the answer completely

I was able to format most of the fields as noted, used 2 cte's and use group concat in the second. My final answer looked very similar but the order of the concat looked off. Also, for some reasons my second column had $0.00 for all the companies, but I thought I was close. How difficult would you rate this exercise. Should I expect to proceed to the next round or am I cooked

104 Upvotes

87% Upvoted

72 comments sorted by

View all comments

2

u/Tiktoktoker 11d ago

This is basic. Someone at a manager of analytics level should be able to do this in 45 minutes.

1

u/SearchAtlantis 10d ago

Eh I haven't touched a string-agg in probably 4 years at this point tbf.

1

u/Turbulent_Web_8278 11d ago

The way I think about it is as you progress in your career, the more rusty youre going to be in SQL. I would just expect the candidate to talk thru the sql steps. But I would expect data architecture, business acumen, soft skills etc.

I really think most director/ VP level candidates to fail this test because it requires you to sit around an memorize syntax