Here is the case:
Create a query that displays the city names, country codes and state province names, but only for those cities that start on S and have at least 8 characters in their name. If city does not have province name assigned, then put Unknown Province.
Here is the solution:
SELECT city, country_ID, NVL(state_province, 'Unknown Province') "PROVINCE" FROM LOCATIONS WHERE (city LIKE UPPER('s%') and LENGTH(city) >= 8 )