SQLite Forum: How to convert the data type of the new column in the view？

table like this:
CREATE TABLE t_spotprice
(
  tradingday       TEXT(20),
  product_name     TEXT(30),
  base_span        REAL DEFAULT 0,
  base_price_ratio REAL DEFAULT 0,
  spot_price       REAL DEFAULT 0,
  future_price     REAL DEFAULT 0
);
create a view like this:

CREATE VIEW 'test1111' AS
  SELECT *,
     (SUM(future_price)) as fp2
  FROM t_spotprice
  WHERE tradingday = 20200103;

The result of view 'test1111' is  is correct!!,but the datatype of fp2 in the view 
 of 'test1111' is unknown.

can I convert to REAL?