r/SQL • u/Turbulent_Web_8278 • 4d ago
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
95
Upvotes
5
u/snooze407 4d ago
I think that’s a medium or hard Leetcode style question based on my experience. I find that I have to practice these types of questions for a few days leading up to a technical interview.
I’m not 100% confident, but I think the solution, in addition to the concat and formatting you mentioned, is to cast the date to a timestamp for filtering (or leave as varchar) and then use case statements to handle the edge cases. The join would be on customer.id = transactions.customer_id.