我的數(shù)據(jù)庫中有這張表：我需要一個(gè)顯示總成本、每月總成本、每月計(jì)數(shù)（roomId）、總計(jì)數(shù)（roomId）的查詢，按房間 ID 分組。我試過這個(gè)查詢，但結(jié)果并不像我需要的SELECT room_id, type, numberOfBeds,        (SELECT SUM(total_cost)          WHERE date_booked BETWEEN '".$dateFrom."' and '".$dateTo."') as monthlyIncome,        SUM(total_cost) as totalIncome,       COUNT(roomId) as totalReservations,       (SELECT COUNT(roomId)          WHERE date_booked BETWEEN '".$dateFrom."' and '".$dateTo."') as monthlyReservation   FROM indvproj_rooms, indvproj_room_booking_details WHERE indvproj_rooms.room_id=indvproj_room_booking_details.roomId;