Oracle SQL "missing keyword" error, but it's not missing at all, where is the query error?

Question

Oracle

Here is the table:


Here is the query:

select t.id, t.dt, t.curr, t.rate from t inner join
(select t.id, COUNT(t.id) as id_count from t
GROUP BY t.id) as t_count on t.id = t_count.id
where t_count.id_count > 1;

Oracle complains:

ORA-00905: отсутствует ключевое слово
00905. 00000 -  "missing keyword"
*Cause:    
*Action:
Error at Line: 3 Column: 16

Answer 1

As far as I remember, aliases for tables go without AS