CREATE TABLE IF NOT EXISTS `battleSessionInfo` (
  `deviceId` varchar(52) NOT NULL,
  `id` varchar(32) NOT NULL DEFAULT '',
  `monster` varchar(32) DEFAULT NULL,
  `mapPoint` varchar(32) NOT NULL,
  `stars` smallint(4) NOT NULL,
  `result` varchar(16) NOT NULL,
  `resultCoins` smallint(4) NOT NULL,
  `spentCoins` int(11) NOT NULL,
  `spentCrystals` smallint(4) NOT NULL,
  `spentRealCoins` int(11) NOT NULL DEFAULT '0',
  `spentRealCrystals` smallint(4) NOT NULL DEFAULT '0',
  `freeBoostersUed` tinyint(2) NOT NULL,
  `coinsBoosterUsed` tinyint(2) NOT NULL,
  `crystalBooseterUsed` tinyint(2) NOT NULL,
  `skipCount` tinyint(4) NOT NULL,
  `sessionLength` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `grade` smallint(4) NOT NULL,
  `enemyGrade` double NOT NULL,
  `speed` int(11) NOT NULL,
  `hits` tinyint(4) NOT NULL DEFAULT '0',
  `turns` smallint(6) NOT NULL DEFAULT '0',
  `helper` smallint(6) NOT NULL DEFAULT '0',
  `healCount` tinyint(2) NOT NULL,
  `healCrystals` smallint(4) NOT NULL,
  `healRealCrystals` smallint(4) NOT NULL,
  `winnerLife` int(11) NOT NULL,
  `misc` int(11) NOT NULL DEFAULT '0',
  `version` varchar(32) DEFAULT NULL,
  `stupid` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `timestamp` (`timestamp`),
  KEY `deviceId` (`deviceId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;

select sum(spentCoins), mapPoint from battleSessionInfo where timestamp between '2014-02-03' and '2014-02-04'