prev question

next question

The cats form a line grouped by color. Inside each color group the cats order themselves by name. Every cat must have a unique number for its place in the line.

We must assign each cat a unique number while maintaining their color & name ordering.

---

Return: unique_number, name, color

Show Table Schema

Cats:

name	varchar
breed	varchar
weight	float
color	varchar
age	int

select * from cats

Click me!

Run Query Show Hint

This query requires:

Correct output but can you use 'row_number'?

Desired output:

unique_number	name	color
1	Ashes	Black
2	Charlie	Black
3	Molly	Black
4	Oscar	Black
5	Smudge	Black
6	Alfie	Brown
7	Misty	Brown
8	Smokey	Brown
9	Felix	Tortoiseshell
10	Millie	Tortoiseshell
11	Puss	Tortoiseshell
12	Tigger	Tortoiseshell

view answer

select row_number() over (order by color,name) as unique_number, name, color from cats

Your output: