Create table as select

CREATE  Table total_reviews
WITH (
format = 'PARQUET',
external_location = 's3://yourname-0000-datalake/parquet/total_reviews'
) 
AS
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;