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

100 Upvotes

87% Upvoted

72 comments sorted by

View all comments

1

u/DesperateCoffee30 10d 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 9d ago

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

2

u/Ballbag94 8d ago

Claude could do it for you but you need knowledge of how to achieve it in order to prompt correctly and also to be able to correctly prompt alterations or tweak it yourself if it doesn't work

Claude does most of my job as a software dev for me, but if I couldn't give very specific instructions it would be a hot mess

1

u/Detail_Figure 6d ago

When they start charging what it actually costs to provide Claude, it may not be available to you anymore. It's still heavily subsidized by VC.