returning count of values in Db with unique fields - sqlite

I'm trying to print count and the occurrence of each entry in table mentioned below. i'm building a java application in NetBeans which uses sqlite as back end.

jar file - sqlite-jdbc-3.7.2.jar

enter image description here