SQL for analysing screen dimensions from CW stats
Sunday, October 16th, 2005SELECT cDesignDate, CONVERT(SUBSTRING_INDEX(cScreen, ‘ ‘, 1), UNSIGNED) AS cScreen FROM tbl_cd_05 WHERE cDesignDate > ‘2005-05-13 00:00:00′ AND cScreen > 800 ORDER BY cScreen;