1WITH stock_t AS
2(
3SELECT YEAR("date") AS "year", "open" AS "open_price"
4FROM (SELECT "date", "open", 
5      ROW_NUMBER() OVER (partition by EXTRACT(YEAR FROM "date"), EXTRACT(MONTH FROM "date") ORDER BY EXTRACT(DAY FROM "date")) AS seq
6      FROM @kaggle.rprkh15_sp500_stock_prices.mmm
7     ) t
8WHERE seq = 1 AND MONTH("date")=1 AND "open" != 0
9ORDER BY 1
10),
11name_t AS
12(
13SELECT "year", SUM("count") AS "babies"
14FROM @kaggle.robikscube_us_baby_name_popularity.names
15WHERE "name" = 'Rose'
16GROUP BY "year"
17)
18SELECT stock_t."year", stock_t."open_price"*15 AS "scaled 3M stock price", name_t."babies" AS "babies named rose"
19FROM stock_t, name_t
20WHERE stock_t."year" = name_t."year" AND stock_t."year" > 2000
21ORDER BY 1