SQL patterns


Suppose you're given the following table, called 'employees':

name job_role
John Analyst
Harry Administrative Business Partner
Sam Software Engineer
Tina Analyst

To test your SQL skills, create a query that returns the name and job_role of each individual who has either a name that contains the letter 'a' or a job role that ends in the letters 'er'.


Access restricted

Subscribe to premium account to see the solution.

Get premium now