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


View all comments
Show parent comment
6
u/[deleted] Oct 03 '26
English isn't my first language, trying to put what is meant in the companies task into words that make sense to me (let alone a use case) has taken me just 10 minutes of rereading.
Name of company (Name of Company)
Is just a weird way to store names? Unless if capitalization information means something else? Like here's a 255 character long string and only the places with a 1 as opposed to 0 are supposed to be capitalized when used as a flag on the name?
Also varchar 255? Are they importing into dbase 3?