#国外的周一是中国周日,要算中国周六周日就是算国外周五周六 select 流出城市,sum(数量) as 流出总人数 from 各城市人口流动表 where year(日期) = 2017 and 交通工具 = '3' and 流出城市 = '北京' and (weekday(日期) = 5 or weekday(日期) = 6)