This is an example of how to SELECT with
WHERE using
"LIKE", "OR" "AND" "NOT" "isin"

The boxes on this page are draggable
     ^^^^^^^^^^^^^^^^^^^^^^^
    The Left SQL used on this page
    SELECT name, family, instinct, height
      FROM dog
     WHERE name LIKE '%A%'
           OR instinct isin 'swimming, attacking'
     ORDER BY instinct
     FORMAT table
    DIV box1
     ^^^^^^^^^^^^^^^^^^^^^^^
    The Right SQL used on this page
    SELECT name, family, instinct, height
      FROM dog
     WHERE name LIKE '%n%'
           AND instinct NOT isin 'attacking, hunting'
           AND height isin 'medium, tall'
     ORDER BY instinct
     FORMAT table
    DIV box2