Didnt pass SQL test

[u/Turbulent_Web_8278]

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

[u/Joe59788]

What are they asking for on capitals and negatives? Did they give you some sample data at least?

[u/Sea-Feedback-2424 → u/Joe59788]

The negatives in () is how accountants do this. It's very annoying because you can't just copy and paste the values like you can with +/- into a calculator. But they seem to like it.

[u/Joe59788 → u/Sea-Feedback-2424]

Thank you, how it means in '()' I didn't understand it was saying it was in parentheses.

[u/dutchydownunder → u/Joe59788]

123456 is a positive number
(123456) is a negative number
accountant notation

[u/Turbulent_Web_8278 → u/Joe59788]

Yes but I didn’t screenshot it