/* Remove any tables that previous existed */


/*
 * Create the following tables and insert the values
 */
/* Employee_T
EmployeeNum	EmployeeName	EmployeeSalary	DepartmentNum
1	Smith	100000	10
2	John	150000	
3	Peter	60000	10
4	Sarah	175000	20
*/


/* Department_T
DepartmentNum	DepartmentName
10	HR
20	Sales
30 	Management
*/



/* Project_T
ProjectNum	ProjectName
1	Community Connector
2	Neighborhood Network
3	Unified Society
*/


/* Works_T
EmployeeNum	ProjectNum	FromDate	ToDate
1	1	01/15/2023	01/15/2024
1	2	01/16/2024	01/15/2025
2	3	04/13/2024	12/31/2024
4	2	01/16/2024	01/15/2025
*/



/*
Complete the following exercises using the tables created above
*/

/* Exercise 01: Return All Employee Data */


/* Exercise 02: Return Employee data for employees with DepartmentNum = Null values */


/* Exercise 03: Calculate what a 10% bonus would be for each employee */


/* Exercise 04: Return employees whose names start with ‘S’ */


/* Exercise 05:	Return the number of employees in the company and the range of their salaries */


/* Exercise 06: Return the names of employees whose salaries are greater than the average salaries for the company */


/* Exercise 07: Return 1) name of employee, 2) his/her salary and 3) the difference between his/her salary and the average salary */