SELECT Quantity, Quantity * 30 / 100 as Score
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 Stock Set Quantity = Quantity * 30 / 100
will update all quantities to 30% of their initial values. Use this query with extreme caution.