SELECT dept_store_chain_id FROM department_stores GROUP BY dept_store_chain_id ORDER BY count(*) DESC LIMIT 2
What are the ids of the two department store chains with the largest number of department stores?
SELECT dept_store_chain_id FROM department_stores GROUP BY dept_store_chain_id ORDER BY count ( * ) DESC LIMIT 2
select dept_store_chain_id from department_stores group by dept_store_chain_id order by count ( * ) desc limit value
What are the ids of the two department store chains with the largest number of department stores ?