Skip to content

Latest commit

 

History

History
16 lines (13 loc) · 359 Bytes

BASICS-Length-based-SELECT-with-LIKE.md

File metadata and controls

16 lines (13 loc) · 359 Bytes

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
-- Replace with your SQL Query
SELECT first_name, last_name FROM names WHERE first_name LIKE '%______%'