USE PUBS
 CREATE
   VIEW b_smith__sales
     AS
        SELECT *
          FROM sales
         WHERE stor_id = 6380
   WITH CHECK OPTION