【答案解析】SELECT FlowerInfo.ID,FlowerInfo.ComName,Delivery.DelSize
FROM FlowerInfo AS F,Delivery AS D
WHERE F.Delivemd=D.id AND D.Category='pot'
ORDER BY F.ComName DESC
[分析] 本题是考查SQL查询语句，在此需要用到两个表：delively和flowerinfo，需要将其正确连接起来。
查询SELECT语句的基本格式如下：
SELECT [ALL|DISTINCT]＜目标列表达式＞[,＜目标列表达式＞]…
FROM＜表名或视图名＞[,＜表名或视图名＞]
[WHERE＜条件表达式＞]
[GROUP BY＜列名1＞[HAVING＜条件表达式＞]]
[ORDER BY＜列名2＞[ASC|DESC]…]
据此，根据题意可得相应的SQL查询语句为：
SELECT FlowerInfo.ID, HowerInfo. ComName, DeliVery.DelSize
FROM FlowerInfoAS F, Delivery AS D
WHERE F.Delivered=D.id AND D.Category='pot'
ORDER BY F.ComName DESC
【答案解析】(1) GREANT INSERT ON TABLE Zone TO Smith WITH GRANT OPTION
(2) REVOKE UPDATE(ComName)ON TABLE FlowerInfo FROM Tom
(3) CREATE VIEW Viewpot(ID,ComName, DeISize)
AS
SELECT FlowerInfo.ID,FlowerInfo.ComName,Delivery.DelSize
FROM FlowerInfo AS F, Delivery AS D
WHERE F.Delivered=D.id AND D.Category='pot'
ORDER BY F.ComName DESC
[分析] SQL语言中的数据控制语句有授权(GRANT)和收获权限(REVOKE)，其基本格式分别如下：
GRANT＜权限＞[,＜权限＞]…
[ON＜对象类型＞＜对象名＞]
TO＜用户＞[,＜用户＞]…
[WHERE GRANT OPTION]
REVOKE＜权限＞[,＜权限＞]…
[ON＜对象类型＞＜对象名＞]
FROM＜用户＞[,＜用户＞]…
据此可得问题(1)对应的SQL语句为GREANT INSERT ON TABLE Zone TO Smith WITH GRANT OPTION；问题(2)对应的SQL语句为REVOKE UPDATE(ComName)ON TABLE FlowerInfO FROM Tom。
问题(3)是创建视图，用CREATE VIEW语句实现，其基本格式为：
CREATE VIEW 视图名(列表名)
AS SELECT 查询子句
[WITH CHECK OPTION]
根据题意可得对应的SQL语句为：
CREATE VIEW Viewpot(ID,ComName,DelSize)
AS
SELECT FlowerInfo.ID,FlowerInfo.ComName,Delively.DelSize
FROM FlowerInfo AS F,Delivery AS D
WHERE F.Delivered=D.id AND D.Category='pot'
ORDER BY F.ComName DESC