SQL patterns
Question
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'.