Skip to content

*DRY* | More readable way of writing the query | Weather Observation Station 6 #6

@NuranTerlan

Description

@NuranTerlan

Change to this ->

SELECT DISTINCT city FROM station
WHERE LEFT(city, 1) IN ('A', 'E', 'I', 'O', 'U')

LEFT(string, char_count) function lets you get the character(s) of a string from the left by specifying a count

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions