SQL Basics — Position
You have access to a table of monsters as follows:
In each row, the characteristic column has a single comma. Your job is to find it using position(). You must return a table with the format as follows:
The comma column will contain the position of the comma within the characteristics string. Order the results by comma.
Hint: The syntax of “POSITION” is
position(',' in characteristics)
select id, name, position(',' in characteristics) as comma from monsters order by comma;