Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
9. Queries Quality and Percentage
On this page

Problem

Table: Queries

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| query_name  | varchar |
| result      | varchar |
| position    | int     |
| rating      | int     |
+-------------+---------+
This table may have duplicate rows.
This table contains information collected from some queries on a database.
The position column has a value from 1 to 500.
The rating column has a value from 1 to 5. Query with rating less than 3 is a poor query.

Problem Definition

We define query `quality

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page