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?