My preference is to pre-calculate and store in the table. Primarily, to reduce any ambiguity if multiple versions of the…