String collation and sort order in PostgreSQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all names sorted alphabetically using the default collation.

PostgreSQL

SELECT name FROM users ORDER BY name [1];

Drag options to blanks, or click blank then click option'

AASC

BDESC

CCOLLATE

DGROUP

Attempts:

3 left

💡 Hint

Common Mistakes

Using DESC sorts in reverse order.

Using COLLATE here without specifying collation causes error.

The ORDER BY clause sorts results. ASC means ascending order (A to Z).

2fill in blank

medium

Complete the code to sort names using the French collation.

PostgreSQL

SELECT name FROM users ORDER BY name COLLATE [1];

Drag options to blanks, or click blank then click option'

A'es_ES.UTF-8'

B'de_DE.UTF-8'

C'en_US.UTF-8'

D'fr_FR.UTF-8'

Attempts:

3 left

💡 Hint

Common Mistakes

Using English or other locale codes instead of French.

Forgetting to put quotes around the collation name.

Using COLLATE 'fr_FR.UTF-8' sorts strings according to French rules.

3fill in blank

hard

Fix the error in the code to sort names case-sensitively using the C collation.

PostgreSQL

SELECT name FROM users ORDER BY name COLLATE [1];

Drag options to blanks, or click blank then click option'

A'POSIX'

B'C'

C'utf8_general_ci'

D'en_US.UTF-8'

Attempts:

3 left

💡 Hint

Common Mistakes

Using MySQL collation names like 'utf8_general_ci' which are invalid in PostgreSQL.

Using locale names like 'en_US.UTF-8' without quotes.

The 'C' collation sorts bytes directly and is case-sensitive but fastest. It is valid in PostgreSQL.

4fill in blank

hard

Fill both blanks to select names sorted ascending with German collation and case-sensitive.

PostgreSQL

SELECT name FROM users ORDER BY name COLLATE [1] [2];

Drag options to blanks, or click blank then click option'

A'de_DE.UTF-8'

BASC

CDESC

D'fr_FR.UTF-8'

Attempts:

3 left

💡 Hint

Common Mistakes

Using French collation instead of German.

Using DESC instead of ASC for ascending order.

'de_DE.UTF-8' sets German collation. ASC sorts ascending.

5fill in blank

hard

Fill both blanks to select names sorted descending with Spanish collation and case-sensitive.

PostgreSQL

SELECT name FROM users ORDER BY name COLLATE [1] [2];

Drag options to blanks, or click blank then click option'

A'es_ES.UTF-8'

BDESC

CASC

D'C'

Attempts:

3 left

💡 Hint

Common Mistakes

Using ascending order when descending is asked.

Using wrong locale codes.

'es_ES.UTF-8' sets Spanish collation. DESC sorts descending.