How to fix only full group by incompatibility error in MySQL SELECT queries

While working on a project recently, I’ve landed on the below error when I tried to run a Codeigniter web application in my local development…