Exercise

Create an array in a query

Sometimes, when you aggregate data, you will still want to preserve some of the original data, and using ARRAY provides a great structure to do this. For example, in this query, you will create a new ARRAY by writing a subquery to do so.

Instructions

100 XP

Create an array of product_id for products weighing 2,220 grams. First, check the ecomm_products table to identify the column that stores weight information.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise