Create a table named REP. The table has the same structure as the SALES$\_$REP table shown on page $1$ of this lab, except the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table. To see the structure of the SALES$\_$REP table, use the DESCRIBE SALES$\_$REP; command. Add the following row to the REP table: rep ID: $35$ first name: Fred last name: Kiser address: $427$ Billings Dr$.$ city: Cody state: WY postal: $82414$ cell phone: $307-555-6309$ commission: $0\mathrm{.}00$ rate: $0\mathrm{.}05$CREATE TABLE REP

$($

REP$\_$ID CHAR$(2)$ PRIMARY KEY,

FIRST$\_$NAME CHAR$(20),$

LAST$\_$NAME VARCHAR$(20),--$ Variable$-$length string

ADDRESS CHAR$(20),$

CITY CHAR$(15),$

STATE CHAR$(2),$

POSTAL CHAR$(5),$

CELL$\_$PHONE CHAR$(12),$

COMMISSION NUMERIC$(7,2),--$ Synonym for DECIMAL

RATE NUMERIC$(3,2)--$ Synonym for DECIMAL

$)$;

DESCRIBE REP;