-- ok
SELECT NJAVATIME_PCTILE, NSUITESCRIPTTIME_PCTILE, NHEADERTIME_PCTILE, NSQLTIME_PCTILE, NPAGEINITTIME_PCTILE, NENDTOENDTIME_PCTILE, NSERVERTIME_PCTILE, NNONSERVERTIME_PCTILE, NWORKFLOWTIME_PCTILE, NPAGELOADTIME_PCTILE, NNETWORKTIME_PCTILE
FROM   SRC_ACS_TH_UI_E2E_DETAILS_TB
WHERE  NJAVATIME_PCTILE IS NULL OR NJAVATIME_PCTILE IS NOT JSON OR
       NSUITESCRIPTTIME_PCTILE IS NULL OR NSUITESCRIPTTIME_PCTILE IS NOT JSON OR
       NHEADERTIME_PCTILE IS NULL OR NHEADERTIME_PCTILE IS NOT JSON OR
       NSQLTIME_PCTILE IS NULL OR NSQLTIME_PCTILE IS NOT JSON OR
       NPAGEINITTIME_PCTILE IS NULL OR NPAGEINITTIME_PCTILE IS NOT JSON OR
       NENDTOENDTIME_PCTILE IS NULL OR NENDTOENDTIME_PCTILE IS NOT JSON OR
       NSERVERTIME_PCTILE IS NULL OR NSERVERTIME_PCTILE IS NOT JSON OR
       NNONSERVERTIME_PCTILE IS NULL OR NNONSERVERTIME_PCTILE IS NOT JSON OR
       NWORKFLOWTIME_PCTILE IS NULL OR NWORKFLOWTIME_PCTILE IS NOT JSON OR
       NPAGELOADTIME_PCTILE IS NULL OR NPAGELOADTIME_PCTILE IS NOT JSON OR
       NNETWORKTIME_PCTILE IS NULL OR NNETWORKTIME_PCTILE IS NOT JSON;

-- ok
SELECT NTOTALTIME_PCTILE, NRECORDS_PCTILE, NREQUESTS_PCTILE, NSEARCHES_PCTILE, NSQLCALLS_PCTILE
FROM   SRC_ACS_TH_UI_SCRIPT_DETAILS_TB
WHERE  NTOTALTIME_PCTILE IS NULL OR NTOTALTIME_PCTILE IS NOT JSON OR
       NRECORDS_PCTILE IS NULL OR NRECORDS_PCTILE IS NOT JSON OR
       NREQUESTS_PCTILE IS NULL OR NREQUESTS_PCTILE IS NOT JSON OR
       NSEARCHES_PCTILE IS NULL OR NSEARCHES_PCTILE IS NOT JSON OR
       NSQLCALLS_PCTILE IS NULL OR NSQLCALLS_PCTILE IS NOT JSON;

-- wrong, fixed
SELECT NTOTALTIME_PCTILE, NRECORDS_95TH, NREQUESTS_95TH, NSEARCHES_95TH, NSQLCALLS_95TH
FROM   SRC_ACS_TH_UI_WF_DETAILS_TB
WHERE  NTOTALTIME_PCTILE IS NULL OR NTOTALTIME_PCTILE IS NOT JSON OR
       NRECORDS_95TH IS NULL OR NRECORDS_95TH IS NOT JSON OR
       NREQUESTS_95TH IS NULL OR NREQUESTS_95TH IS NOT JSON OR
       NSEARCHES_95TH IS NULL OR NSEARCHES_95TH IS NOT JSON OR
       NSQLCALLS_95TH IS NULL OR NSQLCALLS_95TH IS NOT JSON;

-- wrong, fixed
SELECT NPEAKCONCURRENCY_PCTILE
FROM   SRC_ACS_TH_WS_CONCURRENCY_TB
WHERE  NPEAKCONCURRENCY_PCTILE IS NULL OR NPEAKCONCURRENCY_PCTILE IS NOT JSON;

-- ok
SELECT NTOTALTIME_PCTILE
FROM   SRC_ACS_TH_WS_RESTLETS_TB
WHERE  NTOTALTIME_PCTILE IS NULL OR NTOTALTIME_PCTILE IS NOT JSON;

-- wrong, fixed
SELECT NEXECUTIONTIME_PCTILE
FROM   SRC_ACS_TH_WS_TB
WHERE  NEXECUTIONTIME_PCTILE IS NULL OR NEXECUTIONTIME_PCTILE IS NOT JSON;

-- wrong, fixed
SELECT NEXECUTIONTIME_PCTILE
FROM   SRC_ACS_TH_WS_REST_TB
WHERE  NEXECUTIONTIME_PCTILE IS NULL OR NEXECUTIONTIME_PCTILE IS NOT JSON;
