SELECT Quantity, Quantity * 30 / 100 as Score
FROM Stock
Group By Quantity
should give you 30% of quantity in the Score column,
To save this in the database, you need to use an
UPDATE
query.
Update Stock Set Quantity = Quantity * 30 / 100
will update all quantities to 30% of their initial values. Use this query with extreme caution.