SELECT t2.*,t1.corp_avg_sal, (CASE WHEN dept_avg_sal>corp_avg_sal THEN 'higher' WHEN dept_avg_sal<corp_avg_sal THEN 'lower' ELSE 'same' END) AS comparison FROM (SELECT DATE_FORMAT(pay_date,'%Y-%m') AS pay_month,department_id,ROUND(SUM(amount)/COUNT(*),1) AS dept_avg_sal F...