What is the name of the breed with the most dogs?
create table dogs (breed_code varchar, PRIMARY KEY (breed_code)); create table breeds (breed_name varchar, breed_code varchar, PRIMARY KEY (breed_name))
select t1.breed_name from breeds as t1 join dogs as t2 on t1.breed_code = t2.breed_code group by t1.breed_name order by count(*) desc limit 1