I would like to count the popularity of our keywords with each keyword having a unique keywordID.
The following table pulls the data and puts each id together, but I can't figure out how to count the total number of each keyword and order them with the most popular (largest count) on top. Any help would be greatly appreciated. Thanks!
SELECT I.KeywordID, k.keyword FROM IPI_Photographers_KeywordID AS I INNER JOIN IPI_Keywords AS k ON k.KeywordID = I.KeywordID ORDER BY I.KeywordID DESC