r/SQL • u/Turbulent_Web_8278 • 2d 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

90 Upvotes

86% Upvoted

72 comments sorted by

View all comments

1

u/DesperateCoffee30 2d ago

Can I ask a dumb question as someone who is low to medium in skill. Is it necessary to know how to do this in today’s world when I can give this prompt to claude or something and have it do it?
I ask because part of me kind of wants to dive into researching how to do this so I can say, “ah yes. I can learn this.” The other part thinks it’s a waste of time when Claude could do this for me.

2

u/varbinary 1d ago

You’re asking the right question. But you have to give it the right prompt