This article provides an example to find total value of each item based on current stock using multiplication operator in select query.
select itemname, itemprice * qty_hand "Total valueofeach Item" from item;