SELECT misel.day, SUM (misel.population) as 'Misel', SUM (lx.population) as 'LX'
FROM
(SELECT day, population FROM world WHERE player='Misel') misel,
(SELECT day, population FROM world WHERE player='LX') lx,
WHERE misel.day=lx.day
GROUP BY misel.day;
|