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:

Last udpated: March 1, 2018
Created: January 10, 2015