CREATE TABLE ipaddress(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, date VARCHAR(255), ip VARCHAR(255)); INSERT INTO ipaddress(date, ip) VALUES('1-1-2012', '195.165.1.2'), ('1-1-2012', '195.165.1.3'), ('12-2-2012', '195.165.1.8');
Total number of Visits should be grouped based on IP Address
SELECT COUNT(ip), MONTHNAME(STR_TO_DATE(date, '%c-%e-%Y')) as period FROM ipaddress GROUP BY period;