I have a table of choir members with a “name” and a “voice type” column. How can I write a query that orders them by decreasing pitch level of the voice type (i.e. soprano > contralto > tenor > bass)?
Is there in the Google Query Language something similar to FIELD() in MySQL?
I also tried the SORT function, but it does not seem to have an option for custom ordering, either.