Introduction
Exercises
7. Elder cats have some fun

Instruction

Good job! How about this one?

Exercise

Select all data for cats that:

  • are older than 10 years,
  • are either Ragdoll or Abyssinian,
  • have a known favorite toy.

Stuck? Here's a hint!

When looking only for fields that doesn't have the NULL value we can use the IS NOT NULL operator:

AND fav_toy IS NOT NULL

Console

Code editor

Result

TableConsole