SELECT T2.dept_store_id ,  T2.store_name FROM departments AS T1 JOIN department_stores AS T2 ON T1.dept_store_id  =  T2.dept_store_id WHERE T1.department_name  =  "marketing" INTERSECT SELECT T2.dept_store_id ,  T2.store_name FROM departments AS T1 JOIN department_stores AS T2 ON T1.dept_store_id  =  T2.dept_store_id WHERE T1.department_name  =  "managing"
What is the id and name of the department store that has both marketing and managing department?
SELECT T2.dept_store_id , T2.store_name FROM departments AS T1 JOIN department_stores AS T2 ON T1.dept_store_id = T2.dept_store_id WHERE T1.department_name = `` marketing '' INTERSECT SELECT T2.dept_store_id , T2.store_name FROM departments AS T1 JOIN department_stores AS T2 ON T1.dept_store_id = T2.dept_store_id WHERE T1.department_name = `` managing ''
select t2 . dept_store_id , t2 . store_name from departments as t1 join department_stores as t2 on t1 . dept_store_id = t2 . dept_store_id where t1 . department_name = value intersect select t2 . dept_store_id , t2 . store_name from departments as t1 join department_stores as t2 on t1 . dept_store_id = t2 . dept_store_id where t1 . department_name = value
What is the id and name of the department store that has both marketing and managing department ?