要求：查询文章内容既包含aa且包含cc的所有文章的文章标题
查询sql:select kk.`title`,count(1) times from (select `title`, `content` from `article` where `content` in ('aa', 'cc') group by `title`, `content`) kk group by kk.`title` having times>=2;create table if not exists `article` ( `id` int(11) not null auto_increment, `title` varchar(100) not null, `content` varchar(20) not null, primary key (`id`)) engine=innodb default charset=utf8 auto_increment=5 ;insert into `article` (`id`, `title`, `content`) values(1, 'a', 'aa'),(2, 'a', 'cc'),(3, 'a', 'aa'),(4, 'c', 'cc');
效果估计很差，请大牛指点点