1、创建一个仅包含北京客户信息的视图customer_beijing。

2、通过查询customer_beijing视图获得北京客户的信息。

3、修改customer_beijing视图为仅包含北京客户的信誉等级为1的视图。

4、删除customer_beijing视图。

5、创建一个视图ordersum_goods，其中的内容是每种商品的名称和每种商品的订单金额和总和。

6、通过查询ordersum_goods视图，获得每种商品的名称和每种商品的订单金额和总和。

-one, the creation of a Beijing customers include only information customer_beijing View. 2. Inquiries customer_beijing View Beijing customers access information. 3, as amended customer_beijing View Beijing customers include only the credibility of a hierarchy of View. 4, delete customer_beijing View. 5, the creation of a ordersum_goods View, the contents of every commodity and the name of each commodity and the amount of total orders. 6, inquiries ordersum_goods View, access to the name of each commodity and each commodity and the amount of total orders.