Question

Refer the table EMPLOYEE given below and write the MySQL commands for (i) to (x)
Srno Name Extno Salary DOJ Dept Age Gender
1 Jugal 231 25400 2009-12-10 Marketing 35 M
2 Sharmila 232 17800 2009-10-08 HR 40 F
3 Rakesh 237 30000 2008-05-04 Finance 35 M
4 Shyam 235 38000 2008-06-05 IT 38 M
5 Sangeeta 236 28000 2009-06-08 IT 32 F
6 Shalakha 239 36000 2008-06-08 Finance 30 F
7 Sandeep 238 24000 2010-08-05 HR 28 M
8 Vikas 233 Null 2009-12-05 Marketing 31 M
9 Mohan 234 25000 2009-10-15 HR 32 M
10 Arun 240 27000 2009-12-15 Marketing 28 M
i) Create the table with appropriate data type.
ii) Display the different types of department.
iii) Display name and age of the employees who have joined in 2009 and 2010.
iv) Display all the information in descending order of Age.
v) Display the name of employee who do not get salary
vi) Display the name of the employee whose Department is IT and age is less than
35
vii) Display name, dept, salary of female staff in ascending order of their names.
viii) Display the name of the employeewhose name starts with 'J'
ix) Display the name of employees whose dept is null;
x) To list the salary between 25000 to 30000
xi) To list the name of all the employees whose name ends with s
xii) To display the employee name and the incremented value of salary as sal+3000;
xiii) what is the degree and cardinality of above table

Answer 1

Answer:

PLZ mark me as brainlist

Answer 2

Answer:

hegehehhehegeggegeyyehhheueh