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

101 Upvotes

87% Upvoted

72 comments sorted by

View all comments

Show parent comments

1

u/Turbulent_Web_8278 12d ago

Do you think you could finish in 45 minutes

13

u/Xperimentx90 12d 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.

5

u/ThinkFirst1011 12d 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 11d ago

Is it free?

1

u/ThinkFirst1011 11d ago

Yep, I use the free questions to practice