Page 1 of 1

How would you do a SQL query to find out How many reviews were created for each product category that the company had. T

Posted: Sun May 15, 2022 1:09 pm
by answerhappygod
How would you do a SQL query to find out How many
reviews were created for each product category that the company
had.
These are the given datasets:
Olist_order_reviews_dataset: review_id,
order_id, review_score, review_comment_title,
review_comment_message, review_creation_date,
review_answer_timestamp
Olist_products_dataset: product_id,
product_category_name, product_name_lenght,
product_description_lenght, product_photos_qty, product_weight_g,
product_length_cm
Olist_customers_dataset: cust_id,
zip_code_prefix, city, state
Olist_geolocation_dataset: cust_id,
zip_code_prefix, city, state
Olist_order_items_dataset: order_id,
order_item_id, product_id
Olist_order_payments_dataset: order_id,
payment_type, payment_value
Olist_orders_dataset: order_id, cust_id,
order_status, order_purchase_timestamp
Olist_sellers_dataset: seller_id,
zip_code_prefix, city, state