Assume you're given the `customer` table containing all customer details.

The branch manager is looking for a male customer whose name ends with "son" and he's 20 years old. 

Write a SQL query which uses `LOWER` and [`LIKE`](https://datalemur.com/sql-tutorial/sql-like-wildcard-pattern) to find this customer's details. 

### `customers` Schema:
|**Column Name**|**Type**|
|:----|:----|
|customer_id|integer|
|customer_name|string|
|gender|string|
|age|integer|
|zip_code|integer|
|city|string|
|state|string|

### `customers` Example Input:
|customer_id|customer_name|gender|age|zip_code|city|state|
|:----|:----|:----|:----|:----|:----|:----|
|1|Ignace Whillock|Male|30|5464|Johnstonhaven|Northern Territory|
|2|Gray Eskrick|Female|69|8223|New Zacharyfort|South Australia|
|3|Ellswerth Laurent|Male|59|5661|Aliburgh|Australian Capital Territory|


SQL LOWER Practice Exercise

Practice using the LOWER and LIKE string/text commands in SQL! 

SQL LOWER Practice Exercise SQL Interview Question

SQL LOWER Practice Exercise

SQL Interview Question

Schema:

Example Input:

Solution

Column Name	Type
customer_id	integer
customer_name	string
gender	string
age	integer
zip_code	integer
city	string
state	string

customer_id	customer_name	gender	age	zip_code	city	state
1	Ignace Whillock	Male	30	5464	Johnstonhaven	Northern Territory
2	Gray Eskrick	Female	69	8223	New Zacharyfort	South Australia
3	Ellswerth Laurent	Male	59	5661	Aliburgh	Australian Capital Territory