SELECT
  model,
  ld.fcst_init_beg,
  ld.fcst_valid_beg,
  ld.fcst_lead,
  fcst_lev,
  vx_mask,
  obtype,
'TMP' fcst_var,
  'BCRMSE' stat_name,
  'NA' stat_value,
  ld.total,
  ld.fbar,
  ld.obar,
  ld.fobar,
  ld.ffbar,
  ld.oobar,
 ld.mae
FROM
  stat_header h,
  line_data_sl1l2 ld
WHERE
    BINARY h.vx_mask IN ('CONUS')
  AND   BINARY ld.fcst_lead IN ('120000')
  AND   BINARY h.obtype IN ('ADPUPA')
  AND   BINARY h.model IN ('HRRR_verification_mem000', 'RRFS_verification_mem000')
  AND   BINARY h.fcst_lev IN ('P10', 'P20', 'P50', 'P100', 'P150', 'P200', 'P250', 'P300', 'P400', 'P500', 'P700', 'P850', 'P925', 'P1000')
  AND   BINARY h.fcst_var = 'TMP'
  AND ld.stat_header_id = h.stat_header_id;

