我有以下查询,它们都返回相同的结果和行数:select*from(selectUNIX_TIMESTAMP(network_time)*1000asepoch_network_datetime,hbrl.business_rule_id,display_advertiser_id,hbrl.campaign_id,truncate(sum(coalesce(hbrl.ad_spend_network,0))/100000.0,2)asdemand_ad_spend_network,sum(coalesce(hbrl.ad_view,0))asdemand_ad_view,sum(coa