Hi,
I wrote the query below and everything works fine except that the rank does not display correctly in the case of a tie. The calculated rank after the ties would not be correct due to this code in the query:
(SELECT COUNT(*) + 1
FROM History H INNER JOIN
Lifter L ON...