Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
SELECT category, COUNT(*) AS total_products, SUM(stock) AS total_stock, ROUND(AVG(price), 2) AS avg_price, MAX(price) AS highest_price, GROUP_CONCAT(product_name ORDER BY price DESC SEPARATOR ', ') AS product_list FROM products GROUP BY category HAVING total_products > 5 ORDER BY avg_price DESC;
Result
Open