Hi all.

I am trying to create a search that displays 3 columns.

Analysis, Amount, Amount of Positiv results

I have nailed down Analysis, Amount, but have problems displaying Pos. result.

```
SELECT DISTINCT SP.ANALYSIS AS Analysis,COUNT(SP.ANALYSIS) AS Amount
FROM SAMPLE S
INNER JOIN SAMPLE_PARTS SP ON SP.SAMPLEID = S.SAMPLEID
WHERE S.SAMPLE = '18000'
GROUP BY SP.ANALYSIS
```

This gives the folowing:

Analysis | Amount

One | 30

Two | 25

Three | 30

Lets say 10 of each has the value 'POS' in the the column SP.RESULT. How would I then get a 3.rd column in my result displaying the amount of 'POS' reslts?