Sample Interview Question SQL/Database Experience
This is a sample question for interviewees that state that they have SQL and Database experience.
Join the two tables below without using union, inner join, or outer join. Only display the first name, street address, and zip code columns. Name table ========== id (PK) first_name last_name Address table ========== id (PK) name_id (FK) street_addr city state_id (FK) zip_code
select n.first_name, a.street_addr, a.zip_code from name n, address a where a.name_id = n.id