What is the best way to apply Nested Relationship same as SQL Statements?

Hello,   I'm trying to achieve the following SQL Statement's result into Power BI. SELECT Coalesce(c.name, 'Andre Transportører') AS name, Count(*) Bookings...