{He distinguished himself in a number of campaigns, specifically in the Peninsular war, and was lifted to your rank of subject marshal. With the RANK() purpose in SQL, we can try this by adding the PARTITION BY key word and specifying the column to be used for grouping the data. https://edwin28494.thekatyblog.com/27626174/the-greatest-guide-to-rank