Top Selling Products
SQL query for N11
Retrieve the top 10 best-selling products based on the total quantity sold.
SELECT p.product_name, SUM(ol.quantity) AS total_quantity_sold FROM products p INNER JOIN orderlines ol ON p.product_id = ol.product_id GROUP BY p.product_name ORDER BY total_quantity_sold DESC LIMIT 10;
N11 data model
Orders
View 42 columns
IdInteger
StatusInteger
CreateDateDate-time
OrderNumberInteger
PaymentTypeInteger
TotalAmountInteger
CitizenshipIdString
TotalDiscountAmountInteger
OrderItemList_orderItem_idInteger
OrderItemList_orderItem_priceInteger
OrderItemList_orderItem_bundleString
OrderItemList_orderItem_statusInteger
OrderItemList_orderItem_versionInteger
OrderItemList_orderItem_quantityInteger
OrderItemList_orderItem_dueAmountNumber
OrderItemList_orderItem_productIdInteger
OrderItemList_orderItem_attributesString
OrderItemList_orderItem_commissionNumber
OrderItemList_orderItem_productNameString
OrderItemList_orderItem_sppApprovedString
OrderItemList_orderItem_updatedDateDate-time
OrderItemList_orderItem_approvedDateDate-time
OrderItemList_orderItem_mallDiscountInteger
OrderItemList_orderItem_shippingDateDate-time
OrderItemList_orderItem_sellerDiscountInteger
OrderItemList_orderItem_deliveryFeeTypeInteger
OrderItemList_orderItem_productSellerCodeString
OrderItemList_orderItem_stockKeepingUnitIdInteger
OrderItemList_orderItem_sellerInvoiceAmountInteger
OrderItemList_orderItem_sellerCouponDiscountInteger
OrderItemList_orderItem_customTextOptionValuesString
OrderItemList_orderItem_totalMallDiscountPriceNumber
OrderItemList_orderItem_installmentChargeWithVATInteger
OrderItemList_orderItem_shipmentInfo_shipmentCodeInteger
OrderItemList_orderItem_shipmentInfo_campaignNumberInteger
OrderItemList_orderItem_shipmentInfo_shipmentMethodInteger
OrderItemList_orderItem_shipmentInfo_trackingNumberString
OrderItemList_orderItem_shipmenCompanyCampaignNumberInteger
OrderItemList_orderItem_shipmentInfo_shipmentCompany_idInteger
OrderItemList_orderItem_shipmentInfo_campaignNumberStatusInteger
OrderItemList_orderItem_shipmentInfo_shipmentCompany_nameString
OrderItemList_orderItem_shipmentInfo_shipmentCompany_shortNameString
Orderlines
View 35 columns
IdInteger
PriceInteger
BundleString
StatusInteger
VersionInteger
Order_idInteger
QuantityInteger
DueAmountNumber
ProductIdInteger
AttributesString
CommissionNumber
ProductNameString
SppApprovedString
UpdatedDateDate-time
ApprovedDateDate-time
MallDiscountInteger
ShippingDateDate-time
SellerDiscountInteger
DeliveryFeeTypeInteger
ProductSellerCodeString
StockKeepingUnitIdInteger
SellerInvoiceAmountInteger
SellerCouponDiscountInteger
CustomTextOptionValuesString
TotalMallDiscountPriceNumber
InstallmentChargeWithVATInteger
ShipmentInfo_shipmentCodeInteger
ShipmentInfo_campaignNumberInteger
ShipmentInfo_shipmentMethodInteger
ShipmentInfo_trackingNumberString
ShipmenCompanyCampaignNumberInteger
ShipmentInfo_shipmentCompany_idInteger
ShipmentInfo_campaignNumberStatusInteger
ShipmentInfo_shipmentCompany_nameString
ShipmentInfo_shipmentCompany_shortNameString
Top Level Categories
Products
Settlements
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed