select ProductName,UnitPrice from Product where UnitPrice>=30 and UnitPrice<=60
insert into Shipper values('顺风快递','101-6650888')
update Shipper
set Tel='021-33506688' ,ShipperName='顺丰快递'
where ShipperName='顺风快递'
delete from Product
where ProductId in(
select top(1) ProductId from Product
Order by ProductId desc
)
select * from Product
--where ProductName='苹果'
select * from Product