Join 2 tables
Join 2 tables in Athena
- Execute the query below.
select listings.name, count(reviews.review_id) as total_reviews
from
listings
inner join
reviews
on listings.listing_id=reviews.listing_id
group by listings.name;
This query will return the total number of reviews made on each Airbnb location in the listings table.
