get entries by max date
===

i got a table like this:


       CREATE TABLE IF NOT EXISTS `answered` (
         `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
         `question_id` int(11) NOT NULL,
         `correct` tinyint(1) NOT NULL DEFAULT '0',
         `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
         PRIMARY KEY (`id`)
       );

and


    CREATE TABLE IF NOT EXISTS `questions` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `created` datetime DEFAULT NULL,
      PRIMARY KEY (`id`)
    );


i need to select count of correct and !correct answers, BUT: if same question got multiple answers (there mey be more entries in "answered" with same question_id) **only the latest** (determined by "answered.created") shall count.

result structure should be like:

    correct  count 
      0        1 
      1        3 

Can you help me?


Fiddle:
http://sqlfiddle.com/#!2/11073

My trial:

    SELECT a.correct, count(*) as count  FROM answered a JOIN questions q ON a.question_id = q.id GROUP BY correct

this works, but counts same question_ids more than once.

Thank you!
