question

naman88 avatar image
naman88 asked

I am beginner in learning SQL and need some help in how to approach in creating queries in SQL? Would really appreciate help on the requests.

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

sqlmysqljoinfunction
sql-db.png (77.9 KiB)
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·

Post what you've tried so are so that we can try to help

1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·

Searching the wordage for question 2 throws up a couple of deleted Stack questions... Leading me to the thought that this is homework...

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.