Skip to content

Free preview · 5 questions

Try SQL Proficiency

No sign-up. No timer. Five questions sampled at random from the full 23-question test. See how you stack up before requesting access for the full assessment and a verifiable certificate.

Question 1 of 5

0 of 5 answered

What does the following query do? SELECT product, RANK() OVER (PARTITION BY category ORDER BY price DESC) AS r FROM items;