CommencerCommencer gratuitement

Logical operators

You are interested in listing songs performed by Queen. Note that these songs can be composed by either the entire band or an individual band member. In your query you decide to retrieve songs where the composer is Queen or their lead singer, Freddie Mercury.

Remember that there are three logical operators, AND, OR, and NOT that can be used to apply more than one WHERE condition to your query.

Cet exercice fait partie du cours

Introduction to Oracle SQL

Afficher le cours

Instructions

  • Select the song name and composer from the Track table.
  • Filter on tracks that are composed by 'Queen' or by 'Mercury- Freddie'.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Select the song name and composer from the track table
SELECT ___, ___
FROM ___
-- Filter on composer
WHERE Composer ___ ___ 
      ___ Composer ___ ___
Modifier et exécuter le code