help with a sql statement

[tech user]

hello,

I try to execute this sql in mysql shell,but got error as:

mysql> select *  from (select uin,count(*) as dd from active_users where
date >= date_add(curdate(),interval -30 day)  group by uin) where dd >=3;

ERROR 1248 (42000): Every derived table must have its own alias

But I can execute the sql statement of "select uin,count(*) as dd from
active_users where date >= date_add(curdate(),interval -30 day)  group by
uin" successfully.

How to fixup it? thanks!


      Get the name you always wanted with the new y7mail email address.
www.yahoo7.com.au/y7mail