019.sql

/* Q: Show patient_id and first_name from patients where their first_name start and ends with 's' and is at least 6 characters long.

Table Info: patients

+--------------+----------+
| Column Name  | Type     |
+--------------+----------+
| patient_id   | INT      |
| first_name   | TEXT     |
| last_name    | TEXT     |
| gender       | CHAR(1)  |
| birth_date   | DATE     |
| city         | TEXT     |
| province_id  | CHAR(2)  |
| allergies    | TEXT     |
| height       | INT      |
| weight       | INT      |
+--------------+----------+

*/

-- SOLUTION:

select patient_id, first_name
from patients
where first_name like 's%s'
and length(first_name) >= 6;