写出实现语句:查询以花瓶(pot)形式发货的所有鲜花的ID,普通名以及花瓶的规格。得到结果表按普通名

参考答案:

SELECT Flowerinfo.IDFlowerInfo.ComNameDelivery.DelSizeFrom FLOWERINFO ASFDELIVERY AS DWHERE F.Delivered=D.id AND D.Category='pot' ORDER BY F.ComName DESC；SELECT Flowerinfo.ID，FlowerInfo.ComName，Delivery.DelSizeFrom FLOWERINFO ASF，DELIVERY AS DWHERE F.De