Generate personal report

Generate personal report

Hi, im trying to do the next report:

Attack Report for IP Spoofing

January 5000 attacks
February 6500 attacks
March 3200 attacks

I want to obtain this results from the attack year table, but.. i dont know the logical of each one because I imagine that after more than 500,000 records another table is created.

I will query something like this:

SELECT ATTACK, COUNT(*) AS CTN FROM attack_vs_cli_year WHERE ATTACK='"ip spoofing"' and hour between "2007-12-01 00:00:00" and "2008-01-01 00:00:00"

In which order should I query every table? and how is the name assigned.

Thanks