I need to write an SQL statement to run this query:

SALES has the following column names: vendorid, name, upc, move, price, qty, year, store

the table name is SALES... the sales is not a column in the SALES so it needs to be created in the query with the formula as well.

QUESTION BELOW:

Query 4: Return the vendor id, vendor name, product UPC code, move, and sales (price * move/qty) for each product sold by store 100 in 1995. Sort by sales descending. N.B since year is a reserved word in SQL, you will need to surround the field year in quotes in order for it to work.