Performing mathematical operations on conditional retrieved data in MySQL.

[carteldabs]

Hello; I am calculating the variance of 52Hf to 51Hf in the last line of this query by performing certain calculations on the data that is already formatted in a specific way. Since the query recalculates data that has already been calculated based on a specific format, it takes a long time. Is there a more efficient way to do this? For instance, after assigning a name to the query, can I manipulate it in a similar way like this: FORMAT((((52Hf / 51Hf)-1)*100),1) AS '% difference'