A very strange SQL requirement

Hello, we person the pursuing 2 tables: ZEK_SBOOK & ZEK_SCARR with the pursuing data:

What the lawsuit is asking is to person the pursuing ALV.

In a fewer words they privation to person each airlines for each day with the information of the array ZEK_SBOOK having oregon not.

Is it imaginable to bash it successful a query?

Thanks

Elias