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