By using a database class in codeigniter we just need to call group by method. we dont need to write full query. buy using this very easy to do group by on codeigniter The SQL GROUP BY clause is used…