如何从SQL获取以下库存信息？

SELECT dt, sec, t0, p0, t1, p1 FROM
(
SELECT dt, sec,  first_value(tm) over date_window as t0,
  first_value(price) OVER date_window AS p0,
  last_value(tm) OVER date_window AS t1,
  last_value(price) OVER date_window AS p1,
  rank() OVER date_window AS r
 FROM a
 WINDOW date_window AS (PARTITION BY dt, sec ORDER BY tm
  RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
) AS subquery
WHERE r=1;

   Select Coalesce(f.Security, l.Security) security.
      Coalesce(f.Date, l.Date) Date,
      f.TradePrice firstPrice,
      l.TradePrice lastPrice
   From table f Full Join table l
      On f.Security = l.Security
         And f.Date = l.Date
         And f.time = (Select Min(Time)
                       From table
                       Where Security = f.security 
                          And Date = f.Date)
         And l.Time = (Select Max(Time)
                       From table
                       Where Security = l.security 
                          And Date = l.Date)