UsetheSQLCreatecommandtocreateatablewithintheChinookdatabasewiththebelowspecificationsThetablenameshouldbeyourlastnameplusauniquenumber Usethefollowingtonameeachfield(column),withamatchingdatatypeEmployeeID10numericdigits(nodecimalpoints) SSNupto11characters(SSN=socialsecuritynumber) fName up to 12 characterslName up to 12 charactersPositionupto12characters Salary10maximumnumericdigits(including2decimaldigits)PhoneNum12characters. Task 2 -UsetheInsertcommandtoinserttherecords/databelow:Submitonerecordatatime(easiertocorrect
Question:
Use the SQL Create commandto create a table withinthe Chinook databasewith the belowspecifications The table name should be your last name plus a unique number
Use the following to name each field (column), with a matchingdata type EmployeeID 10 numeric digits (no decimalpoints)
SSN up to 11 characters (SSN = socialsecurity number)
fName up to 12 characters lName up to 12 characters Position up to 12 characters
Salary 10 maximumnumeric digits (including 2 decimal digits)PhoneNum 12 characters.
Task 2 - Use the Insert commandto insert the records / data below:Submit one recordat a time (easier to correct any mistakes)
EmployeeID | SSN | fName | lName | Position | Salary | PhoneNum |
100 | 111-11-0607 | John | Smith | Manager | 35000.75 | 800-350-0000 |
200 | 333-22-0607 | John | Jones | Associate | 25000.00 | 202-999-0000 |
300 | 444-44-0607 | Sally | Smith | Manager | 46500.00 | 303-999-0000 |
100, 111-11-0607, John,Smith, Manager, 35000.75, 800-350-0000
200, 333-22-0607, John, Jones, Associate, 25000.00, 202-999-0000
300, 444-44-0607, Sally,Smith, Manager, 46500.00, 303-999-0000
Insert one more record - you determine the content, EXCEPTit must use your name for the first name (fName) and last name lName), and a Salaryof 36900.
Task 3
Use the Select * command to list all fields for all recordsin the table.
Task 4
Use a Select commandto list the EmployeeID, fName, lName, Position,and Salary fields for all employees with alast name of Smith.
Task 5
Use a Select commandto list the EmployeeID, fName,lName, Position, Salary and PhoneNumfields for all employees with a salary greaterthan 20000.
Task 6
Use a Select commandto list the EmployeeID, fName,lName, Position and Salary fieldsfor all Employees with a Salary greaterthan 30000 and less than 45000.
Submit this part of the assignment in a word document. Name your documentLast_Name_SQL(i.e. Smith_SQL).
A description of the most common SQL problems can be found at the end of these instructions. Contactthe instructor with any questions.