UNION for two choices gives "Error SQL: ORA-00907: missing right bracket"

Question

I am trying to execute a UNION of two queries. But I get the following error:

Error at Command Line:9 Column:81 Error report: SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" 

Here is my request:

 SELECT application_id, clicks, datee, client_id FROM( (select APPL_CD AS application_id, count(*) as clicks, to_date((to_char(ACTN_TAKE_DATA_TM, 'dd-mm-yyyy')), 'dd-mm-yyyy') as datee, ALRT_RSPNS_FROM_CLIENT_ID AS client_id from ALRT_PLATFORM_ALRT_HSTRY where ACTN_TAKE_CD is not null group by to_char(ACTN_TAKE_DATA_TM, 'dd-mm-yyyy'), APPL_CD, ALRT_RSPNS_FROM_CLIENT_ID order by datee) UNION ALL (select APPL_CD AS application_id, count(*) as clicks, to_date((to_char(ACTN_TAKE_DATA_TM, 'dd-mm-yyyy')), 'dd-mm-yyyy') as datee, ALRT_RSPNS_FROM_CLIENT_ID AS client_id from ALRT_PLATFORM_ALRT where ACTN_TAKE_CD is not null group by to_char(ACTN_TAKE_DATA_TM, 'dd-mm-yyyy'), APPL_CD, ALRT_RSPNS_FROM_CLIENT_ID order by datee ) ) 

Answer 1

Remove ORDER BY from subqueries:

 SELECT application_id, clicks, datee, client_id FROM( (select APPL_CD AS application_id, count(*) as clicks, to_date((to_char(ACTN_TAKE_DATA_TM, 'dd-mm-yyyy')), 'dd-mm-yyyy') as datee, ALRT_RSPNS_FROM_CLIENT_ID AS client_id from ALRT_PLATFORM_ALRT_HSTRY where ACTN_TAKE_CD is not null group by to_char(ACTN_TAKE_DATA_TM, 'dd-mm-yyyy'), APPL_CD, ALRT_RSPNS_FROM_CLIENT_ID) UNION ALL (select APPL_CD AS application_id, count(*) as clicks, to_date((to_char(ACTN_TAKE_DATA_TM, 'dd-mm-yyyy')), 'dd-mm-yyyy') as datee, ALRT_RSPNS_FROM_CLIENT_ID AS client_id from ALRT_PLATFORM_ALRT where ACTN_TAKE_CD is not null group by to_char(ACTN_TAKE_DATA_TM, 'dd-mm-yyyy'), APPL_CD, ALRT_RSPNS_FROM_CLIENT_ID ) )