sqldevuser·7 वर्ष पहले·discussHere is a single query to get you both solutions. https://pastebin.com/P7LN9jMzThis was after I solved it the old fashioned way though :)