$2\mathrm{.}20$ LAB $-$ Create Student table with constraints

Create a Student table with the following column names, data types, and constraints:

ID $-$ integerwithrange $0$ to $65$ thousand, auto increment, primary key

FirstName variable$-$length string with max $20$ chars, not NULL

LastName

Street $-$ variable$-$length string with max $50$ chars, not NULL

City $-$ variable$-$length string with max $20$ chars, not NULL

State $-$ fixed$-$length string of $2$ chars, not NULL. default $"$TX$"$

Zip$-$integer with range $0$ to $16$ million, nat NULL

Phone $-$ fixed$-$length string of $10$ chars not NULL

Email $-$ variable$-$length string with max $30$ chars, must be unique

Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.

$\backslash$table$[[$LAB$,2\mathrm{.}20\mathrm{.}1$: LAB $-$ Create Student table with constraints$]]$