1SELECT 
2  s.date_formatted AS "date",
3  s.stock_price * 10 AS stock_price,  -- re-scaled the axis to make the price trend more visual.
4  g.gpu_retail_price,
5  g.gpu_used_price
6FROM (
7  SELECT 
8    CAST("date" AS DATE) AS date_formatted,
9    AVG("close") AS stock_price
10  FROM 
11    @kaggle.samanfatima7_nvidia_stocks_historical_data.nvidia
12  GROUP BY 
13    date_formatted
14) s
15INNER JOIN (
16  SELECT 
17    STRPTIME("date", '%d-%m-%y') AS date_formatted,
18    AVG("retail_price") AS gpu_retail_price,
19    AVG("used_price") AS gpu_used_price
20  FROM 
21    @kaggle.mannacharya_historical_gpu_prices_nvidia_and_amd.gpu_price_history
22  GROUP BY 
23    date_formatted
24) g
25ON s.date_formatted = g.date_formatted
26ORDER BY 
27  s.date_formatted ASC;
28