How many department stores does the store chain South have?
create table department_stores (dept_store_chain_id varchar, PRIMARY KEY (dept_store_chain_id)); create table department_store_chain (dept_store_chain_id varchar, dept_store_chain_name varchar, PRIMARY KEY (dept_store_chain_id))
select count(*) from department_stores as t1 join department_store_chain as t2 on t1.dept_store_chain_id = t2.dept_store_chain_id where t2.dept_store_chain_name = "south"