title: Missing Expression Error SQL developer
body: <pre><code>  SELECT distinct
     REPLACE(CM_NAME, '/', ' ') as CM_NAME,  
     TO_CHAR(Booking_Date,'MM/DD/YYYY') AS Booking_Date, 
     where Booking_Date = (sysdate-1),
     sum(Air_Revenue) as TTL_AIRFARE,
     sum(Room_Revenue) as TTL_ROOM,
     sum(Car_Revenue) AS TTL_CAR,
     sum(Activity_Revenue) as TTL_ACTIVITY,
     0 as TTL_CRUISE,
     sum(Air_Revenue + Room_Revenue + Car_Revenue + Activity_Revenue) as 
     TTL_BOOKING
  </code></pre>
  
  <p>so im trying to select yesterdays date using this but i keep getting a missing expression error </p>