01

% any number of characters _ one character

Find any client name with 'LLC' in it using %

select *
from client
where client_name LIKE '%LLC';

This will find any name with 'LLC' at the end

02

If you want to find a name with a letter at the beggining

select *
from employee
where first_name LIKE '%an%';

03

Find employees born in a month with specified number of characters _

select * from employee
where birth_date LIKE '____-02%';