You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, and country . You want to retrieve the first 3 letters of each country name. You decide to use the SUBSTR function to retrieve the first 3 letters of each country name, and use the AS command to store the result in a new column called new_country .
You write the SQL query below. Add a statement to your SQL query that will retrieve the first 3 letters of each country name and store the result in a new column as new_country .
NOTE: The three dots (...) indicate where to add the statement.
I just don't seem to get after watching all the videos. Thank you. in advance for the help