How to get the quantity per state for a product?

Question

SQL

Data set:
Name of goods, condition, quantity of goods.

you need to get
the Name of the product, (Number of states 1 (or 0)), (Number of states 2 (or 0)), (Number of states 3 (or 0)), Amount (number of all states)

Stupid question but I can't figure out how to do it.

Answer 1

Well, the usual conditional aggregation!

SELECT name,
       SUM((state=1)*amount) total_state_1,
       SUM((state=2)*amount) total_state_2,
       SUM((state=3)*amount) total_state_3
FROM tablename
GROUP BY name;