帮忙写几句sqlserver语句。。谢谢。。

来源：百度知道 编辑：UC知道 时间：2024/05/21 16:46:12
以下操作都在SQLServer2000的NORTHwind数据库中。。
7、在orders表中，求出freight总和最大的customers表的customers的姓名。用子查询语句完成（用子查询完成，并截图）
------------------------------------------------------------
6、求出 1996 年中，最好卖的前10种产品的信息。（提示：年份OrderData在Orders表中，卖的数量在Order Details表中，产品的信息在product表中）

7.

select top 1 sum(freight) as freight,b.CompanyName
from orders a
join customers b on a.CustomerID = b.CustomerID
group by b.CompanyName
order by sum(freight) desc

SELECT TOP 1 CustomerID,CompanyName,SUM(Freight) AS sum_freight
FROM Orders
WHERE (CustomerID IN
(SELECT customerid
FROM customers))
GROUP BY CustomerID
ORDER BY sum_freight DESC

SELECT *
FROM Products
WHERE (ProductID IN
((SELECT TOP 10 ProductID
FROM [Order Details]
WHERE (OrderID IN
(SELECT OrderID
FROM orders
WHERE OrderDate BETWEEN '1996-01-01' AND '1996-12-31'))
ORDER BY Quantity DESC)))