kyu7_BASICS_length_based_select_with_like.sql

-- BASICS: Length based SELECT with LIKE:
--
-- https://www.codewars.com/kata/5a8d94d3ba1bb569e5000198
--
-- You will need to create SELECT statement in conjunction with LIKE.
-- Please list people which have first_name with at least 6 character long
--
-- names table schema
--     id
--     first_name
--     last_name
--
-- results table schema
--     first_name
--     last_name

SELECT first_name, last_name FROM names WHERE first_name LIKE '______%';