select order_num,
count(order_num) as order_lines
from OrderItems
group by order_num
order by order_lines

对统计数据进行条件输出，需要先将order_num分组，才能分组统计成功