How can we create queries for these requests? What is the approach for creating queries in SQL. I have attached the database diagram, but as a beginner i am facing few understandings and got errors on below requests.
1. Count all customers without any live listings.
2. Calculate Month over Month Non Refunded BookingAmount performance for each PM customers.
3. Sum all PageViews for 2018 by BrandName
4. Count Number of Bookings by Stay Length (i.e. CheckoutDate-CheckInDate) booked in 2018