Which percent of my new users became paying users in a particular period of time?

You want to know what percent of your new users became paying users within a certain period of time

select  concat(string( 100*( payer/register) ),'%')   as registered_to_paying from 
 (select  1 as dummy, count(distinct uid) as register
from cooladata 
where date_range(doc.date_range) 
and doc.slicers
and event_name='newPlayer') a
(select  1 as dummy, count(*) as payer
from accounts 
where  is_paying=1  ) b 
on a.dummy=b.dummy