Join 2 tables

Join 2 tables in Athena

  1. 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.

DataLake