top of page

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.
bottom of page