SETTING CRITERIA USING WHERE exercises

This page lists the 12 exercises about Setting criteria using WHERE in SQL on our website:

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Relatively easy
Exercise:	Add criteria to a SQL query to show singles released on different dates.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Relatively easy
Exercise:	Create a query to list all of the love and relationships events.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Relatively easy
Exercise:	Use the WHERE clause in a SQL query to return lists of albums filtered by different criteria.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Relatively easy
Exercise:	Use the WHERE clause in a SQL query to test conditions on text fields for a list of music albums.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Average difficulty
Exercise:	Us a WHERE clause to show events which contain two given text strings.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Average difficulty
Exercise:	Use a WHERE clause to show all of the events between two given dates.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Average difficulty
Exercise:	Use the LIKE operator and wildcard characters in the WHERE clause of a SQL query to return a list of live music venues.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Average difficulty
Exercise:	Use the WHERE clause in a SQL query to apply criteria to various date fields in a table of live music venues.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Average difficulty
Exercise:	Use the WHERE clause in SQL queries to combine criteria and filter a list of albums.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Average difficulty
Exercise:	Write SQL queries using the WHERE clause to test for the existence of NULL in a list of music albums.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Harder than average
Exercise:	3 challenging queries combining criteria to find possible data anomalies.

Show this exercise

Software:	SQL
Topic:	Setting criteria using WHERE
Level:	Harder than average
Exercise:	Use wildcards, AND, IN and OR to get a list of events to do with water.

Show this exercise

You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post