DB 5일차 2(group by)

SELECT COUNT(order_id), /*행의 개수가 몇개인가를 알려줌?*/ SUM(stock), MIN(stock), MAX(stock) AS max_stock, SUM(stock) /COUNT(1), AVG(stock) FROM order_mst GROUP BY product_name HAVING max_stock >49; SELECT product_name, price * stock AS total_price FROM order_mst; 각 행안에서 가격과 주문량을 곱한다. SELECT product_name, SUM(price * stock) AS total_price /*상품가격에 대한 총합?.*/ FROM order_mst GROUP BY product_name; SELECT COUNT(..

2022.12.13