Sql:how do I calculate cost of good sold?

The main problem is that you are trying to insert your values as text...assuming that unit_cost and unit_sold are both numeric values of some sort, you need to CAST or CONVERT them to the proper data types.