drop view clerk_v;
create view clerk_v as
	select
			a.name as �n��,
			s.name as �X��,
			c.name as �X��,
			c.sales as ����
		from area a, shop s, clerk c
		where a.code = s.a_code and (s.a_code, s.code) = (c.a_code, c.s_code)
		order by a.code, s.code, c.code
;