<prompt> Kuandika SQL query cheo wanyama kulingana na uzito wao, na 1 kuwa nzito zaidi.  <response>: Assuming you have a table called animals with columns name and weight, the following SQL query can rank the animals based on their weight:SELECT name, weight, DENSE_RANK OVER ORDER BY weight DESC AS rankFROM animalsThis query will return a result set with three columns: name, weight, and rank. The rank column will show the ranking of each animal based on its weight with 1 being the heaviest. 