Description

Table: products

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| product_id    | integer |
| product_name  | varchar |
| category_name | varchar |
+---------------+---------+

product_id is the primary key.

Table: product_sales

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| product_id     | integer |
| sales_quantity | integer |
| rating         | decimal |
+----------------+---------+

product_id is the primary key. rating ranges from 1.0 to 5.0.