Question

Write a SQL query to create the table 'SALESPERSON' with the following structure :

                    Table: SALESPERSON

Field	Type	Size	Constraint
SCODE	Decimal	6	Primary Key
FIRST NAME	Varchar	30	Not Null
LAST NAME	Varchar	30	Not Null
CITY	Varchar	30
SALES	Decimal	8

Answer 1

CREATE TABLE SALESPERSON (SCODE Decimal( 6) Primary Key, FIRSTNAME,Varchar(30) NOTNULL, LASTNNAME Varchar(30) Not NULL, CITY Varchar(30), SALES Decimal(8));