Which states have both owners and professionals living there?
create table owners (state varchar, PRIMARY KEY (state)); create table professionals (state varchar, PRIMARY KEY (state))
select state from owners intersect select state from professionals