SELECT driver_name,driver_phone,
       COUNT(DISTINCT order_id)
FROM driver_info
LEFT JOIN driver_collect 
ON driver_info.driver_id = driver_collect.driver_id
WHERE d_year=2017 AND d_month=7
GROUP BY driver_info.driver_id
HAVING COUNT(DISTINCT order_id) > 30;

SELECT driver_id,driver_name,
       COUNT(DISTINCT d_day)完单天数,
       COUNT(DISTINCT order_id)完单数
FROM driver_daily
WHERE d_year=2017 AND d_month=7
GROUP BY driver_id
HAVING 完单天数 >=10 AND 完单数 >= 20;