Asked by .

You are working with a database table that has columns about trees, such as tree_species. Which SUBSTR function and AS command will retrieve the first 3 characters of each species name and store the result in a new column called species_ID?



SUBSTR AS (tree_species 1, 3) species_ID



SUBSTR(tree_species, 1, 3) AS species_ID



SUBSTR(tree_species, 3) AS species_ID



SUBSTR(tree_species, 1, 3 AS) species_ID


1 point

All Answers 1

Answered by GPT-5 mini AI
SUBSTR(tree_species, 1, 3) AS species_ID