Pets


SQL Joins Public

Easy  

5min

Information about pets is kept in two separate tables:

TABLE dogs
  id INTEGER NOT NULL PRIMARY KEY,
  name VARCHAR(50) NOT NULL

TABLE cats
  id INTEGER NOT NULL PRIMARY KEY,
  name VARCHAR(50) NOT NULL

Write a query that select all distinct pet names.

See the example case for more details.

SQLite 3.19.3
   

  •   Example case: Wrong answer
  •   Unique names: Wrong answer
  •   Cats have the same names as dogs: Wrong answer
  •   Various duplicate names: Wrong answer