我想提取有关客户的详细信息，该客户是订购特定餐厅的最常客户 [英] i want to extract the details about the client who is the most regular customer to order a particullar restaurant

问题描述

我的桌子：

My tables:

NormalClient(clientNo, clientName, streetAddress, suburb, postcode, phoneNo, faxNo, contactName, joiningDate, isRegular)

School(clientNo, clientName, streetAddress, suburb, postcode, phoneNo, faxNo, contactName, joiningDate, salesTaxExNo)

PlatterOrder(orderNo, deliveryDate, deliveryTime, invoiced, isBulk, platterQuantity, discountPercent, clientNo)

SchoolOrder(orderNo, deliveryDate, deliveryTime, invoiced, taxExPercent, clientNo)

SandwichCombo(comboNo, comboName, comboPrice)

Item(name, type, retailCost, stockLevel, unit)

Supplier(supplierNo, supplierName, address, contactNo)

StoreOrder(orderNo, orderDate)

PlatterItem(orderNo, name, quantity)

SchoolCombo(orderNo, comboNo, quantity)

ComboItem(comboNo, name)

SupplierItem(supplierNo, name,currentPrice)

StoreOrderItem(supplierNo, orderNo, name, quantity, cost)

上面是我需要提取它们的表，我确实写了一个查询但是它显示错误

the above are the tables from which i need to extract them,i did write a query but it''s showing error

select clientName,streetAddress,MAX(orderNo) AS max_orders
from NormalClient N,PlatterOrder P
where N.clientNo=P.clientNo
GROUP BY orderNo ;

i这个语言的新手可能会帮助我

i am new to this language could pls help me

推荐答案

试试这个：

Try this:

select clientName, streetAddress, MAX(orderNo) AS max_orders
FROM NormalClient N INNER JOIN PlatterOrder P ON N.clientNo=P.clientNo
GROUP BY clientName, streetAddress

更多关于：

SQL联接 [ ^ ]

SQL连接的可视化表示 [ ^ ]

聚合函数 [ ^ ]

More about:
SQL Joins[^]
Visual Representation of SQL Joins[^]
Aggregate functions[^]

这篇关于我想提取有关客户的详细信息，该客户是订购特定餐厅的最常客户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！