sqldevuser·há 7 anos·discussHere is a single query to get you both solutions. https://pastebin.com/P7LN9jMzThis was after I solved it the old fashioned way though :)