mysql如何写多次查询语句？

Question

mysql select

Answer 1

mysql> select
    -> response_no,interview_date,department,sum(value)
    -> from
    -> questions
    -> where question='Q3' or question='Q4'
    -> group by response_no
    -> having
    -> sum(value) >=5 and sum(value) <10;
+-------------+----------------+------------+------------+
| response_no | interview_date | department | sum(value) |
+-------------+----------------+------------+------------+
|     1110001 | 20140301       |       1101 |          8 |
|     1110002 | 20140301       |       1102 |          5 |
+-------------+----------------+------------+------------+
2 rows in set (0.00 sec)是这样吗？