The underlined attribute(s) are the primary key

Using the following tables create SQL queries:

1. Display the employee names and their corresponding street without any digits in the street name. For instance for Prince Gatlin display nd Ave. In addition make sure you trim any leading spaces.

2. Give all employees of Company1 a 10 percent raise if their salary is less than $100,000 and 5 percent raise otherwise.

Table 1: Employee Employee name Street City Table 2: Works Employee name Company name Salary Table 3: Company Company name City Table 4: Manages Employee_name Manager_name