how to select with group by order by and desc?

how to select with group by order by and desc?

References

Reference NO 1

http://stackoverflow.com/questions/15186374/how-to-select-with-group-by-order-by-and-desc

Reference NO 2

http://stackoverflow.com/questions/8556283/mysql-select-group-by-order

Reference NO 3

http://www.guru99.com/order-by-desc-and-asc.html

Reference NO 4

http://ss64.com/ora/select_group.html

Reference NO 5

http://dev.mysql.com/doc/refman/5.0/en/select.html

Reference NO 6

http://www.w3schools.com/sql/sql_orderby.asp

Reference NO 7

http://msdn.microsoft.com/en-us/library/e9zc0283(v=vs.80).aspx

Reference NO 8

https://kb.askmonty.org/v/select/