| Class | SUNCORP | ALLIANZ | QBE | RACQ |
|---|---|---|---|---|
| 1 | 386.00 | 386.00 | 386.00 | n/a |
| 2 | 386.00 | 386.00 | 386.00 | n/a |
| 3 | 711.40 | 711.40 | 711.40 | n/a |
| 4 | 709.80 | 704.40 | 709.80 | n/a |
| 5 | 78.00 | 78.00 | 78.00 | n/a |
| 6 | 431.40 | 431.40 | 431.40 | n/a |
| 7 | 1214.20 | 1214.20 | 1214.20 | n/a |
| 8A | 521.40 | 521.40 | 521.40 | n/a |
| 8B | 521.40 | 521.40 | 521.40 | n/a |
| 8C | 521.40 | 521.40 | 521.40 | n/a |
| 9A | 476.00 | 476.00 | 476.00 | n/a |
| 9B | 476.00 | 476.00 | 476.00 | n/a |
| 10A base | 716.40 | 716.40 | 716.40 | n/a |
| + per adult passenger seat over 7 | 58.40 | 58.40 | 58.40 | n/a |
| 10B base | 955.40 | 955.40 | 955.40 | n/a |
| + per adult passenger seat over 7 | 58.40 | 58.40 | 58.40 | n/a |
| 11 base | 770.40 | 770.40 | 770.40 | n/a |
| + per adult passenger seat over 7 | 40.00 | 40.00 | 40.00 | n/a |
| 12 | 307.20 | 307.20 | 307.20 | n/a |
| 13 | 390.80 | 390.80 | 390.80 | n/a |
| 14 | 90.40 | 90.40 | 90.40 | n/a |
| 15 | 370.60 | 370.60 | 370.60 | n/a |
| 16 | 612.80 | 612.80 | 612.80 | n/a |
| 17 | 184.00 | 184.00 | 184.00 | n/a |
| 18 | n/a | n/a | n/a | n/a |
| 19 | 141.20 | 141.20 | 141.20 | n/a |
| 20 | 98.60 | 98.60 | 98.60 | n/a |
| 21 | 138.80 | 138.80 | 138.80 | n/a |
| 22 | 28.60 | 28.60 | 28.60 | n/a |
| 23 | 386.00 | 386.00 | 386.00 | n/a |
| 24 | 90.60 | 90.60 | 90.60 | n/a |
| 25 | n/a | n/a | n/a | n/a |
| 26 | 707.20 | 707.20 | 707.20 | n/a |
select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE class END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS SUNCORP,
ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ ,
ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE ,
ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ
FROM (
select *
from
(
select period, rank, class, [insurer] , [gross_comm] AS premium
from [CTP_qld_import]
) src
pivot
(
SUM([premium])
for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 12 order by rank