SELECT
    (
    SELECT
        concat('$',format(max(fidTot),'C'))
    FROM
        `fidelity`
    WHERE
        fidCurDate BETWEEN '2018-02-11' AND '2025-12-31'
) AS TotalMax,
(
SELECT
    concat('$',format(min(fidTot),'C'))
FROM
    fidelity
    WHERE
        fidCurDate BETWEEN '2018-02-11' AND '2025-12-31'
) AS TotalMin,
(
SELECT
    concat('$',format(fidTot,'C'))
FROM
    fidelity order by fidCurDate DESC limit 1
) AS Tot_LastValue,(
SELECT
    concat('$',format(Tot_LastValue-TotalMin, 'C')) as CurrentValue
FROM
    fidelity order by fidCurDate DESC limit 1
) AS TotalDiff

