Search Ranking
You’re given a table that represents search results from searches on Facebook. The query column is the search term, position column represents each position the search result came in, and the rating column represents the human rating of the result from 1 to 5 where 5 is high relevance and 1 is low relevance.
Write a query to get the percentage of search queries where all of the ratings for the query results are less than a rating of 3. Please round your answer to two decimal points.
Example:
Input:
search_results table
| Columns | Type |
|---|---|
result_id |
INTEGER (primary key) |
query |
TEXT |
position |
INTEGER |
rating |
INTEGER |
Output:
| Column | Type |
|---|---|
percentage_less_than_3 |
FLOAT |
.....
Loading editor
Comments