\textbf{Feature:} This query is used to display the top-10 best selling products. \\
\textbf{Location:} In function \texttt{search()} in \texttt{front-end/\_\_init\_\_.py}

\begin{lstlisting}
SELECT p.productID, p.name, p.price, SUM(op.quantity) AS units_sold
FROM order_product op, product p
WHERE p.productID = op.productID
GROUP BY p.productID
ORDER BY units_sold DESC
LIMIT 10;
\end{lstlisting}