SELECT SUBSTRING(START_TIME,1,10),ID,MEAL_ID,2,0,0, ROUND(SUM(CASE WHEN MEAL_ID='1' THEN CASE WHEN DURATION<=180 THEN 22/CHARGE*(CHARGE-(PRE_BALANCE-LEFT_BALANCE ...