Q&A for serious players and enthusiasts of chess
SELECT u.Id, DATEDIFF(DAY, MIN(p.CreationDate), MAX(u.LastAccessDate)) as days_on_platform, MAX(u.reputation), MAX(u.UpVotes), MAX(u.DownVotes), MAX(u.UpVotes)+MAX(u.DownVotes) as TotalVotes FROM users u INNER JOIN Posts p ON (p.OwnerUserId = u.Id) WHERE u.Id IN ('10050435','13031313','11257434','8234870','1003157','4743730','11502477','6603291','4743730','6281993','10839188','3764156','10356933','98463','9155456','10010867','5928186','6668216','11815835','7903243','3959147','11233614','4137876','5681468','5918539','7998795','2737','12031097','1438393','2693546','3675035','3136339','2837262','12635495','206766','6466510','276070','13220140','6149787','13266352','13518221','7811356','12181763','8217279','4275750','294884','11710204','8925535','5957968','12180605','9671423','4422479','1596734','3667938','6649786','10389844','12535090','12231213','11322237','524743','1597603','11734080','10120270','6235128','11778528','9559819','704244','841108','6584883','13733647','13440195','10995254','7979331','13648070','10532500','6941879','11369025','6797586','13637944','5612427') GROUP BY u.Id