Identify the product ID with the product name

1.- In order to know which products were purchased with the item of interest, we’ll need to know the product name. The product names are contained in the ProductInformation collection.

We’ll need to JOIN the ProductInformation collection with the result set from filterResult.

Action Item: Delete all the SQL code in the editor and apply the code snippet below. We're going to be building on the previous query we wrote:

SQL code

Major SQL code highlights:

• We added lines 69-79.

• On line 44, we created a named result, aggregate, from the previous query.

• On line 75 we JOIN the results from line 56 with the ProductInformation collection to see the product id names.

When you run the results, you should see the product names:

Query results

NOTE: You can find us on the Rockset Community if you have questions or comments about the workshop.