Write an SQL query to create table for given dataset. Use the SQL \"DESCRIBE\" c

Question

Write an SQL query to create table for given dataset. Use the SQL "DESCRIBE" command to display the characteristics of the table.

INSERT INTO EMPLOYEEATTRITION
(
AGE,
ATTRITION,
BUSINESSTRAVEL,
DAILYRATE,
DEPARTMENT,
DISTANCEFROMHOME,
EDUCATION,
EDUCATIONFIELD,
EMPLOYEECOUNT,
EMPLOYEENUMBER,
ENVIRONMENTSATISFACTION,
GENDER,
HOURLYRATE,
JOBINVOLVEMENT,
JOBLEVEL,
JOBROLE,
JOBSATISFACTION,
MARITALSTATUS,
MONTHLYINCOME,
MONTHLYRATE,
NUMCOMPANIESWORKED,
OVER18,
OVERTIME,
PERCENTSALARYHIKE,
PERFORMANCERATING,
RELATIONSHIPSATISFACTION,
STANDARDHOURS,
STOCKOPTIONLEVEL,
TOTALWORKINGYEARS,
TRAININGTIMESLASTYEAR,
WORKLIFEBALANCE,
YEARSATCOMPANY,
YEARSINCURRENTROLE,
YEARSSINCELASTPROMOTION,
YEARSWITHCURRMANAGER
)
VALUES
(
38,
'No',
'Travel_Rarely',
702,
'Sales',
'1',
4,
'Life Sciences',
1,
230,
1,
'Female',
59,
2,
2,
'Sales Executive',
4,
'Single',
8686,
12930,
4,
'Y',
'No',
22,
4,
3,
80,
0,
12,
2,
4,
8,
3,
0,
7
);

INSERT INTO EMPLOYEEATTRITION
(
AGE,
ATTRITION,
BUSINESSTRAVEL,
DAILYRATE,
DEPARTMENT,
DISTANCEFROMHOME,
EDUCATION,
EDUCATIONFIELD,
EMPLOYEECOUNT,
EMPLOYEENUMBER,
ENVIRONMENTSATISFACTION,
GENDER,
HOURLYRATE,
JOBINVOLVEMENT,
JOBLEVEL,
JOBROLE,
JOBSATISFACTION,
MARITALSTATUS,
MONTHLYINCOME,
MONTHLYRATE,
NUMCOMPANIESWORKED,
OVER18,
OVERTIME,
PERCENTSALARYHIKE,
PERFORMANCERATING,
RELATIONSHIPSATISFACTION,
STANDARDHOURS,
STOCKOPTIONLEVEL,
TOTALWORKINGYEARS,
TRAININGTIMESLASTYEAR,
WORKLIFEBALANCE,
YEARSATCOMPANY,
YEARSINCURRENTROLE,
YEARSSINCELASTPROMOTION,
YEARSWITHCURRMANAGER
)
VALUES
(
32,
'No',
'Travel_Rarely',
120,
'Research & Development',
'6',
5,
'Life Sciences',
1,
231,
3,
'Male',
43,
3,
1,
'Research Scientist',
3,
'Single',
3038,
12430,
3,
'Y',
'No',
20,
4,
1,
80,
0,
8,
2,
3,
5,
4,
1,
4
);

INSERT INTO EMPLOYEEATTRITION
(
AGE,
ATTRITION,
BUSINESSTRAVEL,
DAILYRATE,
DEPARTMENT,
DISTANCEFROMHOME,
EDUCATION,
EDUCATIONFIELD,
EMPLOYEECOUNT,
EMPLOYEENUMBER,
ENVIRONMENTSATISFACTION,
GENDER,
HOURLYRATE,
JOBINVOLVEMENT,
JOBLEVEL,
JOBROLE,
JOBSATISFACTION,
MARITALSTATUS,
MONTHLYINCOME,
MONTHLYRATE,
NUMCOMPANIESWORKED,
OVER18,
OVERTIME,
PERCENTSALARYHIKE,
PERFORMANCERATING,
RELATIONSHIPSATISFACTION,
STANDARDHOURS,
STOCKOPTIONLEVEL,
TOTALWORKINGYEARS,
TRAININGTIMESLASTYEAR,
WORKLIFEBALANCE,
YEARSATCOMPANY,
YEARSINCURRENTROLE,
YEARSSINCELASTPROMOTION,
YEARSWITHCURRMANAGER
)
VALUES
(
27,
'No',
'Travel_Rarely',
1157,
'Research & Development',
'17',
3,
'Technical Degree',
1,
233,
3,
'Male',
51,
3,
1,
'Research Scientist',
2,
'Married',
3058,
13364,
0,
'Y',
'Yes',
16,
3,
4,
80,
1,
6,
3,
2,
5,
2,
1,
1
);

INSERT INTO EMPLOYEEATTRITION
(
AGE,
ATTRITION,
BUSINESSTRAVEL,
DAILYRATE,
DEPARTMENT,
DISTANCEFROMHOME,
EDUCATION,
EDUCATIONFIELD,
EMPLOYEECOUNT,
EMPLOYEENUMBER,
ENVIRONMENTSATISFACTION,
GENDER,
HOURLYRATE,
JOBINVOLVEMENT,
JOBLEVEL,
JOBROLE,
JOBSATISFACTION,
MARITALSTATUS,
MONTHLYINCOME,
MONTHLYRATE,
NUMCOMPANIESWORKED,
OVER18,
OVERTIME,
PERCENTSALARYHIKE,
PERFORMANCERATING,
RELATIONSHIPSATISFACTION,
STANDARDHOURS,
STOCKOPTIONLEVEL,
TOTALWORKINGYEARS,
TRAININGTIMESLASTYEAR,
WORKLIFEBALANCE,
YEARSATCOMPANY,
YEARSINCURRENTROLE,
YEARSSINCELASTPROMOTION,
YEARSWITHCURRMANAGER
)
VALUES
(
19,
'Yes',
'Travel_Frequently',
602,
'Sales',
'1',
1,
'Technical Degree',
1,
235,
3,
'Female',
100,
1,
1,
'Sales Representative',
1,
'Single',
2325,
20989,
0,
'Y',
'No',
21,
4,
1,
80,
0,
1,
5,
4,
0,
0,
0,
0
);

Explanation / Answer

CREATE TABLE EMPLOYEEATTRITION ( ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY, AGE INT, ATTRITION VARCHAR(20), BUSINESSTRAVEL VARCHAR(40), DAILYRATE INT, DEPARTMENT VARCHAR(20), DISTANCEFROMHOME VARCHAR(10), EDUCATION INT, EDUCATIONFIELD VARCHAR(20), EMPLOYEECOUNT INT, EMPLOYEENUMBER INT, ENVIRONMENTSATISFACTION INT, GENDER VARCHAR(10), HOURLYRATE INT, JOBINVOLVEMENT INT, JOBLEVEL INT, JOBROLE VARCHAR(30), JOBSATISFACTION INT, MARITALSTATUS VARCHAR(10), MONTHLYINCOME INT, MONTHLYRATE INT, NUMCOMPANIESWORKED INT, OVER18 CHAR(1), OVERTIME VARCHAR(5), PERCENTSALARYHIKE VARCHAR(5), PERFORMANCERATING INT, RELATIONSHIPSATISFACTION INT, STANDARDHOURS INT, STOCKOPTIONLEVEL INT, TOTALWORKINGYEARS INT, TRAININGTIMESLASTYEAR INT, WORKLIFEBALANCE INT, YEARSATCOMPANY INT, YEARSINCURRENTROLE INT, YEARSSINCELASTPROMOTION INT, YEARSWITHCURRMANAGER INT ); DESCRIBE EMPLOYEEATTRITION;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.