SELECT e.eventid
  , SUM(c.revenue) as total_revenue
  , SUM(
      CASE
        WHEN c.cart_type = 'ST'
        THEN c.revenue
     END
   ) as standard_revenue
FROM event e
  JOIN cart c
    ON e.eventid = c.eventid
GROUP BY e.eventid