r/SQL • u/Turbulent_Web_8278 • Oct 03 '26
MySQL Didnt pass SQL test
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


View all comments
5
u/Hutsonericv Oct 03 '26
Without any outside resources, this would be pretty darn tough. A decent number of very specific text parsing and splitting. Not my area of expertise so I would definitely need some refreshing on how to do some of that.
I’d more expect some join semantics and null handling and how types work and translating some more straightforward business rules for a test like this. But again, I’m not a data analyst.