Queries Quality and Percentage

Task: Find the quality (avg of rating/position) and poor query percentage (rating < 3 percentage).

Table: Queries

+-------------+-------------+
| Column Name | Type        |
+-------------+-------------+
| query_name  | varchar(30) |
| result      | varchar(50) |
| position    | INT         |
| rating      | INT         |
+-------------+-------------+

Input: Queries table:

+------------+------------------+----------+--------+
| query_name | result           | position | rating |
+------------+------------------+----------+--------+
| Dog        | Golden Retriever | 1        | 5      |
| Dog        | German Shepherd  | 2        | 5      |
| Dog        | Mule             | 200      | 1      |
| Cat        | Shirazi          | 5        | 2      |
| Cat        | Siamese          | 3        | 3      |
| Cat        | Sphynx           | 7        | 4      |
+------------+------------------+----------+--------+

Output:

+------------+---------+-----------------------+
| query_name | quality | poor_query_percentage |
+------------+---------+-----------------------+
| Cat        | 0.66    | 33.33                 |
| Dog        | 2.5     | 33.33                 |
+------------+---------+-----------------------+