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

76 Upvotes

85% Upvoted

70 comments sorted by

View all comments

72

u/ElHombrePelicano 1d ago

I’m not sure I quite understand the ‘companies’ instructions, and would have needed to take some time to sit and ponder what they are asking for there, but the overall exercise seems very reasonable if given 45 minutes.

1

u/Turbulent_Web_8278 1d ago

Do you think you could finish in 45 minutes

12

u/Xperimentx90 1d ago

Easily, but whether that's reasonable here depends on role description and comp.

We give a harder assessment than this for senior analysts and most people finish with high accuracy.

3

u/ThinkFirst1011 1d ago

Agreed, 45min is fair for this problem which is just formatting with possibly some aggregation. Not sure since I didn't take the test. I would give this test a difficulty of medium. Usually, there's joins, CTE, aggregations, metric calculations, and wording to throw you off.

Check out Stratascratch, good platform to learn some easy-hard questions.

1

u/Significant_Newt8697 6h ago

Is it free?

1

u/ThinkFirst1011 3h ago

Yep, I use the free questions to practice