A normalized database is normally made up of multiple tables. Joins are, therefore, required to query across multiple tables.
Public questions (free plan) are common interview questions. They are great for practicing, or if you want to filter candidates using the classic problems.
Information about pets is kept in two separate tables:
TABLE dogs id INTEGER PRIMARY KEY, name VARCHAR(50) NOT NULL TABLE cats id INTEGER PRIMARY KEY, name VARCHAR(50) NOT NULL
Identify all the queries that select all distinct pet names.