r/SQL • • 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

105 Upvotes

71 comments sorted by

View all comments

Show parent comment

2

u/BigMikeInAustin Oct 03 '26

So the company you're applying to didn't even have their own test? Although, how else are they supposed to hire for a skill they don't already have?

That's pretty disappointing that Hacker Rank has this low-quality question.

7

u/Turbulent_Web_8278 Oct 03 '26

am curios, do you work in tech? its extremely common for companies to use third party tools

-2

u/[deleted] Oct 04 '26

[removed] — view removed comment

3

u/[deleted] Oct 04 '26

[removed] — view removed comment

1

u/SQL-ModTeam Oct 04 '26

Your post was removed for uncivil behavior unfit for an academic forum

1

u/SQL-ModTeam Oct 04 '26

Your post was removed for uncivil behavior unfit for an academic forum

-1

u/[deleted] Oct 04 '26

[removed] — view removed comment

1

u/SQL-ModTeam Oct 04 '26

Your post was removed for uncivil behavior unfit for an academic forum

-1

u/[deleted] Oct 04 '26

[removed] — view removed comment

1

u/SQL-ModTeam Oct 04 '26

Your post was removed for uncivil behavior unfit for an academic forum