I have a simple database for a non profit that collects used sports equipment. I need a MySQL query I can plug into phpMyAdmin that does the following-
Finds a specific ITEM (i.e. cleats) and CONDITION (i.e. used) then multiplies the QTY of each ITEM by its UNIT VALUE. Then I need to add all the results together for one total. Any help greatly appreciated!
the parts in red are contradictory
unless there are multiple items that all have a "cleats" type
best would be if you could do a SHOW CREATE TABLE for the table in question
There are multiple lines that have "cleats" as the item. I need to multiply the number of cleats by the unit cost. Once I do that for each line I need to add all the results together.
could you please do a SHOW CREATE TABLE for the table in question