SQLite select Java

with which select can i resolve this problem?

In my app i have 2 types of data in one column in table.

1.type

Jiangmin Backdoor/Huigezi.2007.agfu 2015/07/20
ALYac undetected 2015/07/21
AVG undetected 2015/07/21
AVware undetected 2015/07/21
Ad­Aware undetected 2015/07/21

2.type

 ALYac undetected 2015/07/22
 AVG undetected 2015/07/21
 AVware undetected 2015/07/22
 Ad­Aware undetected 2015/07/22
 AegisLab undetected 2015/07/22

I need count this, where the data were all undetected (type 2.) and where was find some malware (type 1.) because i need to make chart from this data. This 4 rows are one row i database column.

thanks for help