如何做OUTER JOIN和GROUP BY，ORDER BY？

Please, help me with I think simple query I cannot find a solution. Assume I need to use GROUP BY and ORDER BY.. Here is my first table (User profiles where USRID is unique id):Please, help me with I think simple query I can