10-199 C2-1修改订单运费

分数 20

全屏浏览题目

切换布局

作者 柯海丰

单位 浙大城市学院

修改订单表（orders）中的运费，将每单运费（Freight）增加50%
提示：请使用UPDATE语句作答。

表结构:

orders表：

列名	数据类型	长度	主码	说明
OrderID	int	11	√	订单编号
CustomerID	varchar	5		顾客编号
EmployeeID	int	11		员工编号
OrderDate	datetime,			订购日期
RequiredDate	datetime,			预计到达日期
ShippedDate	datetime,			发货日期
ShipVia	int	11		运货商
Freight	decimal	10,4		运费
ShipName	varchar	40		货主姓名
ShipAddress	varchar	60		货主地址
ShipCity	varchar	15		所在城市
ShipRegion	varchar	15		区域
ShipPostalCode	varchar	10		邮政编码
ShipCountry	varchar	15		所在国家

表样例

orders表：

OrderID	CustomerID	EmployeeID	OrderDate	RequiredDate	ShippedDate	ShipVia	Freight	ShipName	ShipAddress	ShipCity	ShipRegion	ShipPostalCode	ShipCountry
10248	VINET	5	1996/7/4 00:00:00	1996/8/1 00:00:00	1996/7/16 00:00:00	3	32.3800	Vins et alcools Chevalier	59 rue de l-Abbaye	Reims		51100	France
10249	TOMSP	6	1996/7/5 00:00:00	1996/8/16 00:00:00	1996/7/10 00:00:00	1	11.6100	Toms Spezialitten	Luisenstr. 48	Mnster		44087	Germany
10250	HANAR	4	1996/7/8 00:00:00	1996/8/5 00:00:00	1996/7/12 00:00:00	2	65.8300	Hanari Carnes	Rua do Pao, 67	Rio de Janeiro	RJ	05454-876	Brazil
10251	VICTE	3	1996/7/8 00:00:00	1996/8/5 00:00:00	1996/7/15 00:00:00	1	41.3400	Victuailles en stock	2, rue du Commerce	Lyon		69004	France
10252	SUPRD	4	1996/7/9 00:00:00	1996/8/6 00:00:00	1996/7/11 00:00:00	2	51.3000	Suprmes dlices	Boulevard Tirou, 255	Charleroi		B-6000	Belgium
10253	HANAR	3	1996/7/10 00:00:00	1996/7/24 00:00:00	1996/7/16 00:00:00	2	58.1700	Hanari Carnes	Rua do Pao, 67	Rio de Janeiro	RJ	05454-876	Brazil
10254	CHOPS	5	1996/7/11 00:00:00	1996/8/8 00:00:00	1996/7/23 00:00:00	2	22.9800	Chop-suey Chinese	Hauptstr. 31	Bern		3012	Switzerland
10255	RICSU	9	1996/7/12 00:00:00	1996/8/9 00:00:00	1996/7/15 00:00:00	3	148.3300	Richter Supermarkt	Starenweg 5	Genve		1204	Switzerland
10256	WELLI	3	1996/7/15 00:00:00	1996/8/12 00:00:00	1996/7/17 00:00:00	2	13.9700	Wellington Importadora	Rua do Mercado, 12	Resende	SP	08737-363	Brazil
10257	HILAA	4	1996/7/16 00:00:00	1996/8/13 00:00:00	1996/7/22 00:00:00	3	81.9100	HILARION-Abastos	Carrera 22 con Ave. Carlos Soublette #8-35	San Cristbal	Tchira	5022	Venezuela

输出样例:

OrderID	CustomerID	EmployeeID	OrderDate	RequiredDate	ShippedDate	ShipVia	Freight	ShipName	ShipAddress	ShipCity	ShipRegion	ShipPostalCode	ShipCountry
10248	VINET	5	1996-07-04 00:00:00	1996-08-01 00:00:00	1996-07-16 00:00:00	3	48.57	Vins et alcools Chevalier	59 rue de l-Abbaye	Reims		51100	France
10249	TOMSP	6	1996-07-05 00:00:00	1996-08-16 00:00:00	1996-07-10 00:00:00	1	17.415	Toms Spezialitten	Luisenstr. 48	Mnster		44087	Germany
10250	HANAR	4	1996-07-08 00:00:00	1996-08-05 00:00:00	1996-07-12 00:00:00	2	98.745	Hanari Carnes	Rua do Pao, 67	Rio de Janeiro	RJ	05454-876	Brazil
10251	VICTE	3	1996-07-08 00:00:00	1996-08-05 00:00:00	1996-07-15 00:00:00	1	62.01	Victuailles en stock	2, rue du Commerce	Lyon		69004	France
10252	SUPRD	4	1996-07-09 00:00:00	1996-08-06 00:00:00	1996-07-11 00:00:00	2	76.95	Suprmes dlices	Boulevard Tirou, 255	Charleroi		B-6000	Belgium
10253	HANAR	3	1996-07-10 00:00:00	1996-07-24 00:00:00	1996-07-16 00:00:00	2	87.255	Hanari Carnes	Rua do Pao, 67	Rio de Janeiro	RJ	05454-876	Brazil
10254	CHOPS	5	1996-07-11 00:00:00	1996-08-08 00:00:00	1996-07-23 00:00:00	2	34.47	Chop-suey Chinese	Hauptstr. 31	Bern		3012	Switzerland
10255	RICSU	9	1996-07-12 00:00:00	1996-08-09 00:00:00	1996-07-15 00:00:00	3	222.495	Richter Supermarkt	Starenweg 5	Genve		1204	Switzerland
10256	WELLI	3	1996-07-15 00:00:00	1996-08-12 00:00:00	1996-07-17 00:00:00	2	20.955	Wellington Importadora	Rua do Mercado, 12	Resende	SP	08737-363	Brazil
10257	HILAA	4	1996-07-16 00:00:00	1996-08-13 00:00:00	1996-07-22 00:00:00	3	122.865	HILARION-Abastos	Carrera 22 con Ave. Carlos Soublette #8-35	San Cristbal	Tchira	5022	Venezuela

update orders set Freight=Freight*1.5