SQL Pattern Queries

Query to get names of employees from employee table who has ‘%’ in Last_Name.

select FIRST_NAME from employee where Last_Name like '%\%%'

Query to get last name from employee table after replacing special character with white space.

select REPLACE(LAST_NAME,'%',' ') from employee