From MySQL documentation https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html

       CREATE TEMPORARY TABLE `TempTable` 
          SELECT * FROM ( WHATHEVER, UNION, ETC ) Z ;  
 
       SELECT * FROM `TempTable`;