You are working with a database table that has columns about products, such as product$\_$name. Which SUBSTR function and AS command will retrieve the first $2$ characters of each product name and store the result in a new column called product$\_$ID$?$

$1$ point

SUBSTR$($product$\_$name, $2)$ AS product$\_$ID

SUBSTR AS $(1,2$ product$\_$name$)$ product$\_$ID

SUBSTR$($product$\_$name, $1,2)$ AS product$\_$ID

SUBSTR$($product$\_$name$)$ AS $(1,2)$ product$\_$ID