Find busiest CarrierId based on FlightDate using SAP CDS View

Input data:

CarrierID Connection ID FlightDate Price

Expected output:

I tried to create two CDS Views to solve the issue but I can only get the busiest CarrierId without date in output. But requirement is to display the date with CarrierID.

I tried to find output with the below views:

1. define view entity View1 as select from /dmo/booking  
   {
    key carrier_id as CarrierId,
        flight_date as FlightDate,     
     count(*) as FlightCount   
   }
   group by
    carrier_id,flight_date

2. define view entity View2 as select from View1
   {
    key CarrierId as CarrierId,
        FlightDate as FlightDate,
    max(FlightCount) as Numberofflight
   }group by CarrierId
   
   This view is not working as we need to add non-aggregated fields in the Group By clause but if I add FlightDate in the Group By then the output will be different.