6 months ago

sql query to get best sellers in ecommerce within a date range?

Posted 6 months ago by danimohamadnejad

`` Hello I have folowing tables in my ecommerce application:

products id name

orders id userid total created_date

order_items id orderid productid quantity

how can I query database to get best seller products which have been ordered within specific date range like 2019-10-1 to 2019-12-5? ``

Please sign in or create an account to participate in this conversation.