Calculating Median Searches per User
Using the table playground.search_freq with each row representing the number of searches (searches column) made by a certain number of users (users column), write a SQL query to calculate the median number of searches per user up to one decimal place and be sure to cast it as a double.
These are the tables to query for this question:
playground.search_freq- searches int
- num_users int
Your answer should include these columns:
- median double
Querying is only for logged in users!
Write Your Query Here (you can run selections by highlighting!)
Query Results
No queries have been run yet.