CREATE TABLE IF NOT EXISTS `history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_student` int(11) NOT NULL,
  `date` date NOT NULL,
  `mesto_rab` text NOT NULL,
  `flag_trud` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `number` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=77 ;

--
-- Дамп данных таблицы `history`
--

INSERT INTO `history` (`id`, `id_student`, `date`, `mesto_rab`, `flag_trud`) VALUES
(1, 9, '2014-04-26', '', 0),
(2, 9, '2014-04-26', '5', 1),
(3, 9, '2014-04-26', '', 0),
(4, 9, '2014-04-26', '.', 1),
(5, 11, '2014-04-26', '', 0),
(6, 29, '2014-04-29',  'школа', 1),
(7, 29, '2014-04-29',  'СОШ №10', 0),
(8, 29, '2014-04-29',  'СОШ №10', 0);

select count(*), date 
from (
   select count(*), year(date) as date 
   from history 
   where year(date) =2014 and flag_trud='1' 
   group by id_student
) as qwe