multiplying - SQL-Doesn't return a value when the columns are multiplied -

I have 3 columns in my DB table, I want to multiply the column, itm_count & amp; Total output for itm_price and given id (itm_id) Total ods_temporder WHERE itm_id = '11 '

as the SELECT sum (itm_price * itm_count)

I use the above SQL query to do this Tried, but the result was zero.

What is this giving you?

  SELECT itm_price, itm_count fds ods_temporder WHERE itm_id = '11 ' 

either itm_price or itm_count NULL? Do you have itm_id = 11? There are rows for