the code run long time but it not delete table

the code below when I run it it not delete table but if i run

DROP TABLE IF EXISTS chg ;
then
I run

CREATE TABLE chg AS
SELECT sename."Date",
    sename.name,
    sename."Open",
    sename."Low",
    sename."Close",
    COALESCE(lag(sename."Open") OVER (PARTITION BY sename.name ORDER BY sename.name), sename."Close") AS lag_start
   
   FROM sename
  ORDER BY sename.name, sename."Date" DESC;

it work

DROP TABLE IF EXISTS chg ;

CREATE TABLE chg AS
SELECT sename."Date",
    sename.name,
    sename."Open",
    sename."Low",
    sename."Close",
    COALESCE(lag(sename."Open") OVER (PARTITION BY sename.name ORDER BY sename.name), sename."Close") AS lag_start
   
   FROM sename
  ORDER BY sename.name, sename."Date" DESC;


--- maxsec

DROP TABLE IF EXISTS maxsec ;

CREATE TABLE maxsec AS


  SELECT t."Date",
    t."Open",
    t.name,
    t."Low",
    t."Close",
    
    t.lag_start,
            ((t."Open" + t.lag_start) - ((2)::numeric * (t."Open" - h.value))) AS profit, 2 as mark,
    ROUND( ((((t."Open" + t.lag_start) - ((2)::numeric * (t."Open" - h.value))) * (100)::numeric) / t."Open") ,2)  AS perprofit,
    h.value
   FROM ("chg" t
   JOIN helpertable h ON ((((t."Open" - t."Low") - h.value) >= (0)::numeric)));

----


DROP TABLE IF EXISTS goodsec ;

CREATE TABLE goodsec AS


SELECT "maxsec".name,
    "maxsec".value,
    sum("maxsec".perprofit) AS profit100,
    count("maxsec".value) AS countva
   FROM "maxsec"
  GROUP BY "maxsec".name, "maxsec".value;

Select allOpen in new window