# 章节末测验

+ 以下哪个查询的结果里会包含卫星最多的行星？
  + A. Query 1
  + B. Query 2
  + C. 两个都可以

```
/* Query 1 */
select name from universe.planets
where id =any
  (select planet_id from
    (select planet_id, count(*) moon_count 
     from universe.moons group by planet_id having moon_count > 0) v
  );

/* Query 2 */
select name from universe.planets
where id = (select planet_id from 
  (select planet_id, count(*) moon_count 
   from universe.moons group by planet_id order by moon_count limit 1) v 
  );

```
**********************************************************************************
答案: A