I have a table

```
Sno|PID |Tests|Result
1   1001 HB    10
2   1001 HB    12
3   1001 TEMP  98
4   1002 TEMP  98  
5   1002 HB    120
6   1003 TEMP   98

```

**Query 1** - I need only those records where Test - HB is done more than 1. In the above case, the output would be the first two rows. {I need duplicate rows}

I am trying it with below query but does not work

```
SELECT  PID,test_name, COUNT(MRN) AS dup
FROM `report` WHERE Tests = 'HB' GROUP BY Tests HAVING dup > 1

```

**Query 2** - I need only those records where Test - HB is not done at all. In the above case, the output would be the last row. PID - 1003 

Thanks