ERROR 1064 (42000) works on WebSQL but not on MySQL

Question

When using mysql to run this query,

select country_code, Avg(freq) as frequency
from 
(
    select t1.country_code, t1.freq
    from avg_call country_code_final t1        
    union all
    select t2.country_code, t2.freq
    from calls_at_one xx_country_code_frequency t2 
)
group by country_code;

I received an

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' select t1.country_code, t1.freq from avg_call country_code_final t1
union all select t2.country_code, t2.freq from calls_at_one xx_country_code_frequency t2 ) group by country_code;'`

I tried running this on WebSQL it work.