You are working with a database table that contains invoice data. The table includes columns about billing location such as billing_city, billing_state, and billing_country. You want to retrieve the first 4 letters of each city name. You decide to use the SUBSTR function to retrieve the first 4 letters of each city name, and use the AS command to store the result in a new column called new_city.
You write the SQL query below. Add a statement to your SQL query that will retrieve the first 4 letters of each city name and store the result in a new column as new_city.
NOTE: The three dots (...) indicate where to add the statement.
1
2
3
4
5
6
7
SELECT
invoice_id,
...
FROM
invoice
ORDER BY
billing_city
RunReset
What invoice ID number appears in row 7 of your query result?
- 23?
-390?
-97?
-206?