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.
- Example case: Wrong answer
- Unique names: Wrong answer
- Cats have the same names as dogs: Wrong answer
- Various duplicate names: Wrong answer