USE svwiki_p;

SELECT SUBSTR(ipb_timestamp,9,2) AS Timme, 

CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=1) AS INTEGER) AS Måndag,

CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=2) AS INTEGER) AS Tisdag,

CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=3) AS INTEGER) AS Onsdag,

CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=4) AS INTEGER) AS Torsdag,

CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=5) AS INTEGER) AS Fredag,

CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=6) AS INTEGER) AS Lördag,

CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=0) AS INTEGER) AS Söndag,

COUNT(*) AS Totalt FROM ipblocks

WHERE ipb_timestamp >= DATE_ADD(NOW(),INTERVAL -28 DAY)

GROUP BY Timme

ORDER BY Timme;

​

SELECT COUNT(*) FROM ipblocks WHERE ipb_timestamp >= DATE_ADD(NOW(),INTERVAL -28 DAY);