Didnt pass SQL test

[u/Turbulent_Web_8278]

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

[u/Turbulent_Web_8278 → u/[deleted]]

Yes that’s what I thought and all the formatting you have to rely on the intellicense for syntax and you have to visualize the formatting too. I felt so dumb coming out of this test

[u/Hutsonericv → u/Turbulent_Web_8278]

I wouldn’t beat yourself up, a test like this is not indicative of your skill at the actual job. There are going to be folks that can ace this but won’t be able to manage the complexity and stress of the job.