SELECT dr.job_id, boss_id, company_id, post_time, salary, job_city 
FROM job_info ji 
INNER JOIN deliver_record dr ON ji.job_id = dr.job_id 
GROUP BY ji.job_id, boss_id, company_id, post_time, salary, job_city

太苟了， 题目说的是有排序， 但实际上答案是没有排序的，所以去掉order by 就好了