mysql 쿼리 질문이요~

sqlite> create table a (
   ...> id number,
   ...> name varchar(10),
   ...> date varchar(10)
   ...> );
sqlite> insert into a ( 1, 'AA', '2012-05-03');
Error: near "1": syntax error
sqlite> insert into a values ( 1, 'AA', '2012-05-03');
sqlite> insert into a values ( 2, 'BB', '2012-05-03');
sqlite> insert into a values ( 3, 'CC', '2012-05-03');
sqlite> insert into a values ( 4, 'CC', '2012-05-04');
sqlite> insert into a values ( 5, 'CC', '2012-05-04');
sqlite> select name, count(*) as cnt, date group by name,date;
Error: no such column: name
sqlite> select name, count(*) as cnt, date from a group by name,date;
AA|1|2012-05-03
BB|1|2012-05-03
CC|1|2012-05-03
CC|2|2012-05-04
sqlite>