有一个关于商品供应及顾客订单的数据库。其中包括四个表表中信息如下：供应表applyid、name、sid、price说明id供应厂家编号name供应厂家名称sid商品编号price商品价格。顾客表customersgid、name、address、balance说明gid顾客编号address地址balance余额。订单表orderssid、gid、date 说明sid商品编号gid顾客编号dat

SELECT id, name FROM supply;
SELECT gid, name, balance FROM customers WHERE address = '长春';
SELECT name, count FROM goods WHERE name LIKE '%可乐' ORDER BY count DESC;
SELECT gid, date FROM orders WHERE sid = 101;
INSERT INTO goods (sid, name, count) VALUES (204, '可口可乐', 900);
SELECT MAX(count) AS max_count, MIN(count) AS min_count, SUM(count) AS total_count FROM goods;

原文地址: http://www.cveoy.top/t/topic/cVlt 著作权归作者所有。请勿转载和采集!