CREATE VIEW myview AS
SELECT *
    FROM vnp14imgtdl_nrt_global_24h a, states b
      WHERE st_within(a.geom, b.geom)
      AND a.confidence = 'high'
      order by b.statename;

ERROR: column "gid" specified more than once
SQL state: 42701