SELECT pref_T.pref_cd, pref_T.pref_name FROM pref_T INNER JOIN shop_T ON pref_T.pref_cd = shop_T.pref WHERE ((pref_T.area_code Between 6 And 7)and((shop_T.light_F)<>0)and((shop_T.status)<>9)) GROUP BY pref_T.area_code, pref_T.pref_cd HAVING (pref_T.area_code Between 6 And 7) ORDER BY pref_T.area_code, pref_T.disp_no5