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:

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:

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

Last updated