multiply sql query code example

Example: how to multiply in sql

SELECT name,
 price*quantity AS total_price
FROM purchase;