total_answers_by_year

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select T.Country, count(*) from(
select
  case
  WHEN UPPER(Location) LIKE '%INDIA%' THEN 'India'
  WHEN UPPER(Location) LIKE '%UK%' THEN 'United Kingdom'
  END AS Country
      FROM Users
) AS T
group by T.Country
order by count(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results