JooqQueryTest.java

            final Field<String> status = DSL.decode()
                .when(NODES.SUCCESS.eq(0), "fail")
                .when(NODES.SUCCESS.eq(1)
                    .and(NODES.START_INDEX.equal( NODES.END_INDEX)),
                    "empty")
                .otherwise("nonempty")
                .as("status");
            db.select(status, DSL.count().as("count"))
                .from(NODES)
                .groupBy(status)
                .fetch()
                .forEach(record -> System.out.println(record.value1() + ": "
                    + record.value2()));