初学者，哪位大神帮帮忙。。。。

Question

select d.department_name,
mt.type_name,
'2017-02-07' as startdate,
'2017-02-07' as enddate,
m.msgcount * ms.proportion / 100 record_count
from (select ml.message_type, count(1) msgcount
from message_send_log ml
group by ml.message_type) m,
mesophase_statistics ms,
base_department d,
base_message_type mt
where m.message_type = ms.message_type
and ms.dept_id = d.department_id
and ms.message_type = mt.type_id
and to_date(ml.send_time,'yyyy-MM-dd') >= to_date('2017-02-07', 'yy-mm-dd')

Answer 1

select ml.message_type, count(1) msgcount
from message_send_log ml
你的ml 职业这两列，没send_time，所以就无效了