Practice Center: Select with where like

Step 1/3: Your goal

Display all first names (first_name), last names (column last_name) and phone numbers (column phone_number) of clients which last name (column last_name) ends with the two letters “ra”. This exercise corresponds to the lesson on SQL where condition.

Step 2/3: Get started

Enter the corresponding query in the edit box below and click on the “Submit Query” button underneath:

Step 3/3: Verify your results

After clicking on “Submit Query”, you should see below a table with 3 columns and 6 rows:

Next lesson: combining conditions in SQL.
Next exercise: inner join.

Share on:

Something not clear? Ask your question here:

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


Last udpated: September 10, 2017
Created: January 10, 2015