Which dogs are owned by someone who lives in Virginia? List the owner's first name and the dog's name.
create table dogs (name varchar, owner_id varchar, PRIMARY KEY (name)); create table owners (first_name varchar, owner_id varchar, state varchar, PRIMARY KEY (first_name))
select t1.first_name, t2.name from owners as t1 join dogs as t2 on t1.owner_id = t2.owner_id where t1.state = 'virginia'