Execute the following SQL queries, Make sure you execute them in this order!

7. 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.

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

Table 1: Employee Employee name William Gates II1 Warren Buffett Lakshmi Mittal Carlos Slim Helu Street University St Alaskan Way 1st Ave 1st Ave City Redmond Omaha London London