由于有两个表，您应该在一个公共列（即id）上连接它们，并应用算法进行转换

• 华氏到摄氏（减去32乘以5/9）
• 英寸到厘米（乘以2.54）

样本数据：

SQL> with
  2  cities (id, city) as
  3    (select 13, 'Phoenix' from dual union all
  4     select 44, 'Denver'  from dual union all
  5     select 66, 'Caribou' from dual
  6    ),
  7  stats (id, month, temp_f, rain_i) as
  8    (select 13, 1, 57.4, 0.31 from dual union all
  9     select 44, 1, 27.3, 0.18 from dual
 10    )

查询方式：

11  select c.id, c.city, s.month,
 12    --
 13    s.temp_f,
 14    round((s.temp_f - 32) * 5/9, 1) temp_c,
 15    --
 16    s.rain_i,
 17    round(s.rain_i * 2.54, 2) rain_cm
 18  from cities c left join stats s on s.id = c.id
 19  order by c.id, s.month;

        ID CITY         MONTH     TEMP_F     TEMP_C     RAIN_I    RAIN_CM
---------- ------- ---------- ---------- ---------- ---------- ----------
        13 Phoenix          1       57,4       14,1        ,31        ,79
        44 Denver           1       27,3       -2,6        ,18        ,46
        66 Caribou

SQL>