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

$1$ point

SUBSTR$($ice$\_$cream$\_$flavor, $1,4)$ AS flavor$\_$ID

SUBSTR$($ice$\_$cream$\_$flavor $1,4,$ AS$)$ flavor$\_$ID

SUBSTR$(1,4)$ ice$\_$cream$\_$flavor, AS flavor$\_$ID

SUBSTR$($ice$\_$cream$\_$flavor, $4)$ AS flavor$\_$ID