Browse 553 attributed reviews, viewable separately for our classroom and online training
Practise SQL in your browser with SQL Fiddle
Part six of a sixteen-part series of blogs

Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!

  1. Installing and configuring SQL Fiddle
  2. SQL Fiddle Exercise 1 - SELECT
  3. SQL Fiddle Exercise 2 - Order By
  4. SQL Fiddle Exercise 3 - Numeric Filters
  5. SQL Fiddle Exercise 4 - Date Filter
  6. SQL Fiddle Exercise 5 - Text Filters (this blog)
  7. SQL Fiddle Exercise 6 - Cast or Convert Functions
  8. SQL Fiddle Exercise 7 - Conditional Function
  9. SQL Fiddle Exercise 8 - Counting Words
  10. SQL Fiddle Exercise 9 - Formatted Dates
  11. SQL Fiddle Exercise 10 - Date Calculations
  12. SQL Fiddle Exercise 11 - Inner Join
  13. SQL Fiddle Exercise 12 - Outer Join
  14. SQL Fiddle Exercise 13 - Grouping Data
  15. SQL Fiddle Exercise 14 - Having
  16. SQL Fiddle Exercise 15 - All together now!

Posted by Sam Lowrie on 01 July 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

SQL Fiddle Exercise 5 - Text Filters

Some of these regions have space to grow; others don't. Write a query to list all the regions that have a space in their name.

SQL Fiddle

Huh - not sure these places do have much more room!

 

If they don't have any space let's try the opposite - write another query to show all the regions that don't have a space in them:

SQL Fiddle

Not sure if London has space, but there is room for all up North.

Remember to use LIKE with wildcards (% or _), and also the NOT keyword.

Check out the answer here.

This blog has 0 threads Add post