I want to multiply 2 cells for each row and put the value of that in the last column called Total. Can this be done by a normal query?
Example:
Pieces | Price | Total 6 | 4 | null // should be 24 2 | 10 | null // should be 10