ExercExercise 3
To get a better sense of the sales, let’s look at the correlation between the quantity sold and the price for each subcategory. We will break this process down into three steps.
Find out the quantity sold by their productID.
Next we will query the listing price by their productID and their respective category and subcategory.
Finally, we will JOIN both results together so we will know how many were sold by their category and subcategoryise 3
To get a better sense of the sales, let’s look at the correlation between the quantity sold and the price for each subcategory. We will break this process down into three steps.
Find out the quantity sold by their productID.
Next we will query the listing price by their productID and their respective category and subcategory.
Finally, we will JOIN both results together so we will know how many were sold by their category and subcategoryExercise 3
To get a better sense of the sales, let’s look at the correlation between the quantity sold and the price for each subcategory. We will break this process down into three steps.
Find out the quantity sold by their productID.
Next we will query the listing price by their productID and their respective category and subcategory.
Finally, we will JOIN both results together so we will know how many were sold by their category and subcategory