ORA-00923: ключевое слово FROM не найдено там, где ожидалось

У меня есть приведенный ниже код, и я получаю сообщение об ошибке: ORA-00923: ключевое слово FROM не найдено там, где ожидалось при четвертом выборе (*). Кто-нибудь знает почему?

Я просмотрел другие сообщения и не нашел своего решения.

select plan_date as Week,
      plan_date+7 as "Week + 7",
      plan_date+14 as "Week + 14",
      plan_tower, 
      plan_rice_type, 
      plan_hours/100 as Plan_Count,

      (select count(*)
       from smart_rice_cooker rc
       where rc.tower = p.plan_tower and
             rc.rice_type = p.plan_rice_type and
             rc.status <> 'Cancelled' and
             rc.actual_fd_date between p.plan_start_date and p.plan_end_date
      ) as Delivered_FD_Count,

      (select count(*)
       from smart_rice_cooker rc
       where rc.tower = p.plan_tower and
             rc.rice_type = p.plan_rice_type and
             rc.status <> 'Cancelled' and
             rc.actual_fd_date is null and
             rc.target_fd_date between p.plan_start_date and p.plan_end_date
       ) as Target_FD_Count

       ***(select count(*)
       from smart_rice_cooker rc
       where rc.tower = p.plan_tower and
             rc.rice_type = p.plan_rice_type and
             rc.status <> 'Cancelled' and
             rc.actual_td_date between p.plan_start_date+7 and p.plan_end_date+7
      ) as Delivered_TD_Count,

      (select count(*)
       from smart_rice_cooker rc
       where rc.tower = p.plan_tower and
             rc.rice_type = p.plan_rice_type and
             rc.status <> 'Cancelled' and
             rc.actual_rt_date between p.plan_start_date+14 and p.plan_end_date+14
      ) as RT_Delivered_Count,

      (select count(*)
       from smart_rice_cooker rc
       where rc.tower = p.plan_tower and
             rc.rice_type = p.plan_rice_type and
             rc.status <> 'Cancelled' and
             rc.actual_rt_date is null and
             rc.target_rt_date between p.plan_start_date+14 and p.plan_end_date+14
       ) as RT_Target_Count

from smart_plan p
order by plan_tower, plan_rice_type, plan_date