Order Type SQL Statement

SELECT SQL_CALC_FOUND_ROWS o.*, 
  (CASE TRUNCATE((
      SELECT (SUM(oi.case_or_pack)/COUNT(*)) 
      FROM order_items as oi, orders as o 
      WHERE o.order_id = oi.order_id)
      ,2)  
    WHEN 2.00 
      THEN "CA" 
    WHEN 1.00 
      THEN "EA" 
    ELSE "CE" 
  END) as order_type 
FROM orders AS o'
WHERE o.status IN (1,2,4,11);