SELECT “vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” AS “Parent Category Label”,

“vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” AS “Product Category”,

1 AS “Level”,

1 AS “Path”,

SUM(“vw_bluetooth_failure_by_device_by_profile”.”failure_count” ) AS “Failure Count”

FROM “public”.”vw_bluetooth_failure_by_device_by_profile” “vw_bluetooth_failure_by_device_by_profile”

GROUP BY “vw_bluetooth_failure_by_device_by_profile”. ”device_manufacturer”

UNION

 

SELECT “vw_bluetooth_failure_by_device_by_profile”.”device_model” as [Parent Category Label],

“vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”device_model”  as [Product Category],

2 AS [Level],

1 AS [Path],

SUM(“vw_bluetooth_failure_by_device_by_profile”.”failure_count” ) AS “Failure Count”

FROM “vw_bluetooth_failure_by_device_by_profile”

GROUP BY “vw_bluetooth_failure_by_device_by_profile”.”device_model”, “vw_bluetooth_failure_by_device_by_profile”.’device_manufacturer”

UNION

 

SELECT “vw_bluetooth_failure_by_device_by_profile”.”make” as [Parent Category Label],

“vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”device_model” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”make”  as [Product Category],

3 AS [Level],

1 AS [Path],

SUM(“vw_bluetooth_failure_by_device_by_profile”.”failure_count” ) AS “Failure Count”

FROM “vw_bluetooth_failure_by_device_by_profile”

GROUP BY “vw_bluetooth_failure_by_device_by_profile”.”make”, “vw_bluetooth_failure_by_device_by_profile”.”device_model”, “vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer”

UNION

 

SELECT “vw_bluetooth_failure_by_device_by_profile”.[Model] as [Parent Category Label],

“vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”device_model” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”make” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”model”  as [Product Category],

4 AS [Level],

1 AS [Path],

SUM(“vw_bluetooth_failure_by_device_by_profile”.”failure_count” ) AS “Failure Count”

FROM “vw_bluetooth_failure_by_device_by_profile”

GROUP BY “vw_bluetooth_failure_by_device_by_profile”.[Model], “vw_bluetooth_failure_by_device_by_profile”.”make”, “vw_bluetooth_failure_by_device_by_profile”.”device_model”, “vw_bluetooth_failure_by_device_by_profile”. ”device_manufacturer”

UNION

 

 

SELECT “vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” as [Parent Category Label],

“vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” as [Product Category],

1 AS [Level],

203 AS [Path],

SUM(“vw_bluetooth_failure_by_device_by_profile”.”failure_count” ) AS “Failure Count”

FROM “vw_bluetooth_failure_by_device_by_profile”

GROUP BY “vw_bluetooth_failure_by_device_by_profile”. ”device_manufacturer”

UNION

SELECT “vw_bluetooth_failure_by_device_by_profile”.”device_model” as [Parent Category Label],

“vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”device_model”  as [Product Category],

2 AS [Level],

203 AS [Path],

SUM(“vw_bluetooth_failure_by_device_by_profile”.”failure_count” ) AS “Failure Count”

FROM “vw_bluetooth_failure_by_device_by_profile”

GROUP BY “vw_bluetooth_failure_by_device_by_profile”.”device_model”, “vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer”

UNION

SELECT “vw_bluetooth_failure_by_device_by_profile”.”make” as [Parent Category Label],

“vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”device_model” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”make”  as [Product Category],

3 AS [Level],

203 AS [Path],

SUM(“vw_bluetooth_failure_by_device_by_profile”.”failure_count” ) AS “Failure Count”

FROM “vw_bluetooth_failure_by_device_by_profile”

GROUP BY “vw_bluetooth_failure_by_device_by_profile”.”make”, “vw_bluetooth_failure_by_device_by_profile”.”device_model”, “vw_bluetooth_failure_by_device_by_profile”. ”device_manufacturer”

UNION

SELECT “vw_bluetooth_failure_by_device_by_profile”.”model” as [Parent Category Label],

“vw_bluetooth_failure_by_device_by_profile”.”device_manufacturer” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”device_model” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”make” & ” > ” & “vw_bluetooth_failure_by_device_by_profile”.”model” as [Product Category],

4 AS [Level],

203 AS [Path],

SUM(“vw_bluetooth_failure_by_device_by_profile”.”failure_count” ) AS “Failure Count”

FROM “vw_bluetooth_failure_by_device_by_profile”

GROUP BY “vw_bluetooth_failure_by_device_by_profile”.”model”, “vw_bluetooth_failure_by_device_by_profile”.”make”, “vw_bluetooth_failure_by_device_by_profile”.”device_model”, “vw_bluetooth_failure_by_device_by_profile”. ”device_manufacturer”

 

Close Bitnami banner
Bitnami