用MySQL写一个查询平均住宿天数超过2天的宾馆信息显示宾馆编码和宾馆名称代码

SELECT hotel_code, hotel_name FROM bookings WHERE DATEDIFF(checkout_date, checkin_date) > 2 GROUP BY hotel_code, hotel_name HAVING AVG(DATEDIFF(checkout_date, checkin_date)) > 2;