PostgreSQL unit-8

SELECT * FROM users WHERE date_of_birth BETWEEN DATE '2000-05-05' AND  '2008-01-01' ORDER BY date_of_birth;

SELECT * FROM users WHERE email LIKE '%.com';

SELECT * FROM users WHERE email LIKE '%web%';

SELECT * FROM users WHERE email LIKE '_______@%';

SELECT * FROM users WHERE country ILIKE 'p%';

SELECT * FROM users WHERE country LIKE 'p%';