Difficult problem solving coding test on hacker rank, along with some relatively ok SQL table manipulation questions including inner join, outer join, self join and basic conditions and aggregation as well