Home > OS >  SQL query with count aggregate
SQL query with count aggregate

Time:11-17

How to returns the cities in California and their install rate (users who installed the app out of the users who had an activity), ordered from the highest rate to the lowest? Table name = Events

SELECT location, COUNT(*) AS num_of_installs
FROM data_mapping.Events
WHERE location LIKE '           
  • Related