CREATE OR REPLACE VIEW view_1 AS


    SELECT  g.*

    FROM    goods g, shop_goods sg, shops s, departs d

    WHERE   sg.s_g_name = g.g_article AND

            sg.s_g_shop = s.sh_id     AND

            d.d_shop    = s.sh_id     AND

            d.d_name    = 'Кухня'     AND

            g.g_price   = (

                SELECT min(g.g_price)

                FROM   goods g

            )

;