The main advice I have is that for the complex SQL ones, test simple queries with output printed step by step. That's how I was able to debug and finally get the right answer. The final answer had me using coalesce and order by and using the SEPARATOR keyword, and then putting that in a subquery which was selected and then joined on other tables. Also don't forget to add in WHERE X is NOT NULL to y our query to further filter.