sippy_openshift=> select prow_jobs.name, count(*) from prow_job_run_tests inner join prow_job_runs on prow_job_run_id = prow_job_runs.id inner join prow_jobs on prow_job_runs.prow_job_id = prow_jobs.id where test_id in (select id from tests where name like '%prow job name should match network type%' limit 1) and status = 13 group by prow_jobs.name order by count(*) desc;
                                                    name                                                     | count 
-------------------------------------------------------------------------------------------------------------+-------
 periodic-ci-openshift-release-master-ci-4.12-upgrade-from-stable-4.11-e2e-azure-upgrade                     |   784
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-aws-heterogeneous                               |    77
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-serial-aws-heterogeneous                        |    74
 periodic-ci-openshift-multiarch-master-nightly-4.12-upgrade-from-stable-4.11-ocp-e2e-aws-arm64              |    70
 periodic-ci-openshift-release-master-nightly-4.12-upgrade-from-stable-4.11-e2e-metal-ipi-upgrade            |    49
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-serial-aws-arm64                                |    42
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-aws-arm64                                       |    38
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-upgrade-aws-arm64                               |    37
 periodic-ci-openshift-release-master-nightly-4.12-e2e-vsphere-techpreview                                   |    36
 periodic-ci-openshift-release-master-nightly-4.12-e2e-ovirt                                                 |    36
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-aws-arm64-techpreview-serial                    |    34
 periodic-ci-openshift-release-master-nightly-4.12-e2e-vsphere                                               |    34
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-aws-arm64-single-node                           |    33
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-aws-arm64-techpreview                           |    33
 promote-release-openshift-machine-os-content-e2e-aws-4.12                                                   |    30
 periodic-ci-openshift-release-master-ci-4.12-upgrade-from-stable-4.11-e2e-ovirt-upgrade                     |    30
 periodic-ci-openshift-release-master-nightly-4.12-e2e-vsphere-serial                                        |    29
 periodic-ci-openshift-release-master-nightly-4.12-e2e-vsphere-upi-serial                                    |    28
 periodic-ci-openshift-release-master-nightly-4.12-e2e-vsphere-upi                                           |    28
 periodic-ci-openshift-release-master-nightly-4.12-e2e-aws-proxy                                             |    27
 periodic-ci-openshift-release-master-nightly-4.12-e2e-vsphere-techpreview-serial                            |    27
 periodic-ci-openshift-release-master-nightly-4.12-e2e-metal-ipi-virtualmedia                                |    25
 periodic-ci-openshift-release-master-nightly-4.12-e2e-gcp-rt                                                |    24
 periodic-ci-openshift-release-master-nightly-4.12-e2e-aws-fips                                              |    24
 periodic-ci-openshift-release-master-nightly-4.12-e2e-metal-ipi-serial-virtualmedia                         |    23
 periodic-ci-openshift-release-master-nightly-4.12-e2e-aws-single-node                                       |    21
 periodic-ci-openshift-release-master-nightly-4.12-e2e-alibaba                                               |    21
 periodic-ci-openshift-release-master-nightly-4.12-e2e-aws-single-node-serial                                |    20
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-remote-libvirt-s390x                            |    15
 periodic-ci-openshift-release-master-nightly-4.12-openshift-e2e-aws-single-node-workers-upgrade-conformance |    14
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-remote-libvirt-ppc64le                          |    14
 periodic-ci-openshift-multiarch-master-nightly-4.12-upgrade-from-nightly-4.11-ocp-remote-libvirt-ppc64le    |    14
 periodic-ci-openshift-multiarch-master-nightly-4.12-upgrade-from-nightly-4.11-ocp-e2e-aws-arm64             |    14
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-jenkins-e2e-remote-libvirt-ppc64le                  |     8
 periodic-ci-openshift-release-master-nightly-4.12-e2e-aws-workers-rhel8                                     |     8
 periodic-ci-openshift-release-master-nightly-4.12-e2e-metal-ipi-upgrade                                     |     8
 periodic-ci-shiftstack-shiftstack-ci-main-periodic-4.12-e2e-openstack-ccm-install                           |     8
 periodic-ci-shiftstack-shiftstack-ci-main-periodic-4.12-e2e-openstack-techpreview-parallel                  |     8
 periodic-ci-shiftstack-shiftstack-ci-main-periodic-4.12-upgrade-from-stable-4.11-e2e-openstack-upgrade      |     8
 periodic-ci-openshift-release-master-ci-4.12-upgrade-from-stable-4.11-e2e-vsphere-upgrade                   |     7
 periodic-ci-openshift-multiarch-master-nightly-4.12-upgrade-from-nightly-4.11-ocp-remote-libvirt-s390x      |     7
 periodic-ci-openshift-release-master-ci-4.12-upgrade-from-stable-4.11-e2e-aws-upgrade-workload              |     7
 periodic-ci-shiftstack-shiftstack-ci-main-periodic-4.12-e2e-openstack-serial                                |     7
 periodic-ci-shiftstack-shiftstack-ci-main-periodic-4.12-e2e-openstack-parallel                              |     7
 periodic-ci-openshift-release-master-nightly-4.12-e2e-aws-single-node-workers                               |     6
 periodic-ci-shiftstack-shiftstack-ci-main-periodic-4.12-e2e-openstack-techpreview-serial                    |     6
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-image-ecosystem-remote-libvirt-ppc64le              |     6
 periodic-ci-openshift-release-master-ci-4.12-e2e-network-migration                                          |     4
 periodic-ci-openshift-release-master-nightly-4.12-e2e-gcp-fips-serial                                       |     4
 periodic-ci-openshift-release-master-nightly-4.12-e2e-azure-fips                                            |     4
 periodic-ci-openshift-release-master-ci-4.12-upgrade-from-stable-4.11-e2e-aws-uwm                           |     4
 periodic-ci-openshift-release-master-nightly-4.12-e2e-aws-fips-serial                                       |     4
 periodic-ci-openshift-release-master-nightly-4.12-e2e-aws-csi-migration                                     |     4
 periodic-ci-openshift-release-master-ci-4.12-e2e-network-migration-rollback                                 |     4
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-aws-upi-arm64                                   |     4
 periodic-ci-openshift-release-master-nightly-4.12-e2e-azure-fips-serial                                     |     3
 periodic-ci-openshift-release-master-nightly-4.12-e2e-gcp-csi-migration                                     |     3
 periodic-ci-openshift-release-master-nightly-4.12-e2e-gcp-fips                                              |     3
 periodic-ci-openshift-release-master-nightly-4.12-e2e-metal-ipi-serial-ipv4                                 |     3
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-image-ecosystem-aws-arm64                           |     3
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-jenkins-e2e-aws-arm64                               |     2
 periodic-ci-openshift-release-master-nightly-4.12-upgrade-from-stable-4.10-e2e-aws-upgrade-paused           |     2
 periodic-ci-openshift-release-master-ci-4.12-e2e-aws-ovn-upgrade                                            |     1
 periodic-ci-openshift-release-master-ci-4.12-upgrade-from-stable-4.11-e2e-aws-upgrade-infra                 |     1
 periodic-ci-openshift-multiarch-master-nightly-4.12-ocp-e2e-serial-remote-libvirt-ppc64le                   |     1