MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH yourTable AS (

SELECT 'aa' AS Id1, 33 AS Code, NULL AS `Range` UNION ALL

SELECT 'ab', 12, '001' UNION ALL

SELECT 'ac', 53, '001' UNION ALL

SELECT 'ad', NULL, NULL UNION ALL

SELECT NULL, 36, '002'

)

SELECT

'Id1' AS Field,

COUNT(CASE WHEN Id1 IS NULL THEN 1 END) AS NoNull,

COUNT(Id1) AS NoNonNull

FROM yourTable

UNION ALL

SELECT 'Code', COUNT(CASE WHEN Code IS NULL THEN 1 END), COUNT(Code)

FROM yourTable

UNION ALL

SELECT 'Range', COUNT(CASE WHEN `Range` IS NULL THEN 1 END), COUNT(`Range`)

FROM yourTable;