a) Add at least 8 records into each

a) Add at least 8 records into each created tables.
b) Specify name, email and department name of the employees that have been working at least six months.
c) Specify the names of the employees whore have either ‘C++’ or ‘.NET’ skills.
d) List all employee names, manager names, manager emails of those employees.
e) Specify the departments which have >=2 employees, print out the list of departments’ employees right after each department.
f) List all name, email and skill number of the employees and sort ascending order by employee’s name.
g) Use SUB-QUERY technique to list out the different employees (include name, email, birthday) who are working and have multiple skills.
h) Create a view to list all employees are working (include: name of employee and skill name, department name).

Results (Vietnamese) 1:

a) Add at least 8 records into each created tables.b) Specify name, email and the department name of the employees that have been working at least six months.c) Specify the names of the employees have either whore ' C ++ ' or '. NET ' skills.d) List all employee names, the manager names, the manager emails of those employees. e) Specify the departments which have > = 2 employees, print out the list of departments ' employees right after each department.f) List all name, email and action number of the employees and sort ascending order by employee's name. g) Use SUB-QUERY technique to list out the different employees (include name, email, birthday) who are working and have multiple skills.h) Create a view to list all employees are working (include name of employee and skill name, department name).

Results (Vietnamese) 2:

a) Add at Least 8 records Into each created tables.
b) Specify name, email and department name of the employees có được working at nhất six months.
c) Specify the names of the employees whore have hoặc 'C ++' or '. NET 'skills.
d) list all employee names, manager names, emails manager of những employees.
e) Specify the departments mà have> = 2 employees, print out the list of departments' employees right after each department.
f) list all name , email and skill number of the employees and sort ascending order by employee's name.
g) Use SUB-QUERY technique to list out the khác employees (include name, email, birthday) who are working and have multiple skills.
h) Create a view to list all employees are working (include: name of the employee and skill name, department name).