How to correlate data between 2 tables?
SELECT 
   Name,
   SUM(DC.data) AS Data,
   MAX(DC.TS) AS TS
FROM II
INNER JOIN DC ON DC.id = II.id
GROUP BY II.Name
ORDER BY 3 DESC


In stead of ORDER BY 3 DESC, you could also write ORDER BY MAX(DC.TS) DESC.