Code

1. Practical coding

In a text editor of your choice write pseudo code to solve the following problem: Write a function that removes non ASCII characters from a String.

 

2. SQL query

The EMPLOYEE table has the following attributes: NAME, DEPT_ID, and SALARY. The DEPARTMENT table has the following attributes: ID and NAME.
Write a query that shows the department names along with the highest salary in each department

 

3. SQL modification

Modify query from the previous task (2. SQL query), so the results are only departments with the highest salary above 3000.

 

4. SQL modification

Modify the query from the second task (2. SQL query) to ensure all departments are displayed in the results, even if there is no employee for the department.