CREATE TEMP TABLE FUNCTION TEST_COVERAGE_VIEW () AS SELECT -- Target, -- BuildNum, CoverageMethods.Method AS MethodName, CoverageMethods.Package AS Package, CoverageMethods.Class AS ClassName, -- count % coverage 1 - (SUM(IFNULL( CoverageResults.CoverageData.instructions_missed, 0 )) / SUM(CoverageResults.CoverageData.instructions_total)) AS Coverage -- 1-(missed/total) FROM `/span/global/blackbox-eng-jobs:database`.TestSuiteResults.TestSuiteResultsByBranchTarget JOIN `/span/global/blackbox-eng-jobs:database`.CoverageResults USING (TestSuiteResultsId) HASH JOIN `/span/global/blackbox-eng-jobs:database`.CoverageMethods USING (CoverageResultsId) WHERE HasCoverage AND BuildNum = build_num AND Branch = "git_udc-car-dev" AND Target = "cf_x86_64_auto-userdebug_coverage" AND TestSuite = "coverage/complete_car_coverage" GROUP BY MethodName, Package, ClassName, TestSuite ; SELECT MethodName FROM TEST_COVERAGE_VIEW WHERE Coverage = 0 AND Package LIKE "android.car%" ORDER BY MethodName;