Average rating per group and month
SQL query for Shiji ReviewPro
Calculate the average rating for each hotel group for each month.
SELECT group_id, EXTRACT(MONTH FROM review_date) AS month, AVG(rating) AS average_rating FROM available_groups GROUP BY group_id, month
Shiji ReviewPro data model
Available Hotels
Available Groups
Lodging Grs Daily
Lodging Index Daily
Lodging Index Avg
Lodging Grs Avg
Group Index Daily
Surveys
Lodging Index Cqi
Lodging Review Language Distribution
Lodging Semantic Mentions
Lodging Semantic Categories Decreasing G R I
Account Lodging Competitors
Lodging Semantic Categories Increasing G R I
Lodging Semantic Mentions Categories
Lodging Semantic Mentions Language
Lodging Review Country Distribution
Lodging Review Country Index
Lodging Review Published
Lodging Review Responses
Survey Responses
Survey Guests
Lodging Delivery Index
Lodging Review Rating Distribution
Lodging Source Detail Product
Lodging Triptype Distribution
Group Index Avg
Group Avg Daily
Group Review Country Distribution
Group Review Country Index
Group Review Triptype Index
Group Review Brand Competition
Survey Questions
Survey Scores Days Rating
Survey Scores Days Customscore
Survey Scores Days Nps
Survey Nps Group Competition
Survey Brand Impact
Competitor Index Daily
Competitor Index Avg
Competitor Review Rating Distribution
Competitor Source Detail Product
Competitor Review Language Distribution
Competitor Review Language Index
Competitor Review Country Index
Lodging Avg Daily
Lodging Grs Distribution
Lodging Semantic Mentions Sources
Lodging Semantic Concepts
Lodging Semantic Categories
Lodging Review Summaries
Lodging Review Private
Lodging Semantic Mentions Details
Survey Score Rating
Survey Score Nps
Survey Score Customscore
Survey Nps Competition
Lodging Review Triptype Index
Lodging Review Language Index
Lodging Index Cqi Sources
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed