Mine

SELECT COUNT(echostar.UPGRADES.campaign) AS Count_of_Campaign, echostar.UPGRADES.campaign, ecreek.agent_hr.position_title FROM ecreek.agent_hr INNER JOIN echostar.UPGRADES ON ecreek.agent_hr.AgentId = echostar.UPGRADES.seller WHERE ecreek.agent_hr.position_title = '300a' AND echostar.UPGRADES.`timestamp` BETWEEN '11/1/2007' AND '11/1/2007' GROUP BY echostar.UPGRADES.campaign;+----+-------------+----------+------+----------------+----------------+---------+-------+------+----------------------------------------------+| id | select_type | table    | type | possible_keys  | key            | key_len | ref   | rows | Extra                                        |+----+-------------+----------+------+----------------+----------------+---------+-------+------+----------------------------------------------+|  1 | SIMPLE      | UPGRADES | ref  | timestamp      | timestamp      | 3       | const |   10 | Using where; Using temporary; Using filesort ||  1 | SIMPLE      | agent_hr | ref  | position_title | position_title | 7       | const |   89 | Using where                                  |+----+-------------+----------+------+----------------+----------------+---------+-------+------+----------------------------------------------+2 rows in set, 7 warnings (0.00 sec)