MySQL query

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.

Thanks

could you please do a SHOW CREATE TABLE for the table in question