CREATE OR REPLACE VIEW view_7 AS


    SELECT   DISTINCT s.s_name, sh.sh_name, COUNT(sl.*)

    FROM     system s, shops sh, sale sl, employees e, departs d

    WHERE    sl.sl_employee = e.e_id   AND

             e.e_depart     = d.d_id   AND

             d.d_shop       = sh.sh_id AND

             sh.sh_id       = s.sh_id

;