I have a list of users with corresponding date of birth. Is there any possibility I can get a percentage of users born between 1990 and 2000 in a single SQL query?
The query I tried is as follows:
Select (Select count(distinct user) as users from Visitors where birthyear between 1990 and 2000)/count(distinct user) from Visitors
But it gives me a zero as result.