Here is a short overview on ISO 639 language code statistics. If you have any other queries to add, please tell me. See Creating statistics on ISO 639 language codes for how this was generated.

Versions of tables:

ISO 639-1

• Count of ISO 639-1 language codes: 184
  Query: SELECT COUNT(*) AS count FROM ISO_639_2 WHERE Part1 != ''
• Count of ISO 639-1 collective language codes: 1
  Query: SELECT COUNT(*) as count FROM ISO_639_2 LEFT JOIN ISO_639_3 USING (Id) WHERE ISO_639_3.Id IS NULL AND ISO_639_2.Part1 != ''

  Alpha2	Alpha3 (B/T)	English Name
  bh	bih	Bihari

ISO 639-2

• Count of ISO 639-2 language codes (without reserved): 484
  Query: SELECT COUNT(*) as count FROM ISO_639_2
• Count of languages entries with different B/T codes: 20
  Query: SELECT COUNT(*) as count FROM ISO_639_2 WHERE Part2T != ''
• Count of collective language codes (not in ISO 639-3): 66
  Query: SELECT COUNT(*) as count FROM ISO_639_2 LEFT JOIN ISO_639_3 USING (Id) WHERE ISO_639_3.Id IS NULL
• Count of collective language codes for languages of a language family which don't have an own code: 34
  Query: SELECT COUNT(*) as count FROM ISO_639_2 LEFT JOIN ISO_639_3 USING (Id) WHERE ISO_639_3.Id IS NULL AND Ref_Name_En like '%(Other)%'
• Count of deprecated ISO 639-2(B) codes: 2
  Query: SELECT COUNT(*) as count FROM ISO_639_3 LEFT JOIN ISO_639_2 USING (Id) where ISO_639_2.Part2T = '' AND ISO_639_3.Part2T != ISO_639_3.Part2B;

  Alpha3 (T)	deprecated Alpha3 (B)	English Name
  hrv	scr	Croatian
  srp	scc	Serbian

ISO 639-3

• Count of ISO 639-3 language codes: 7700
  Query: SELECT COUNT(*) as count FROM ISO_639_3
• Count of special codes in ISO 639-3: 4
  Query: SELECT COUNT(*) as count FROM ISO_639_3 WHERE Scope='S'

  Alpha3	English Name
  mis	Uncoded languages
  mul	Multiple languages
  und	Undetermined
  zxx	No linguistic content

• Count of constructed language codes in ISO 639-3: 20
  Query: SELECT COUNT(*) as count FROM ISO_639_3 WHERE Type='C'
• Count of ancient language codes in ISO 639-3: 112
  Query: SELECT COUNT(*) as count FROM ISO_639_3 WHERE Type='A'
• Count of historical language codes in ISO 639-3: 63
  Query: SELECT COUNT(*) as count FROM ISO_639_3 WHERE Type='H'
• Count of extinct language codes in ISO 639-3: 427
  Query: SELECT COUNT(*) as count FROM ISO_639_3 WHERE Type='E'
• Count of living language codes in ISO 639-3: 7074
  Query: SELECT COUNT(*) as count FROM ISO_639_3 WHERE Type='L'

Macrolanguage codes

• Count of macrolanguage codes in ISO 639-3: 57
  Query: SELECT COUNT(*) as count FROM ISO_639_3 WHERE Scope='M'
• Count of (non deprecated) language codes belonging to a macrolanguage code: 400
  Query: SELECT COUNT(I_Id) as count FROM ISO_639_3_Macrolanguages WHERE I_Status = 'A'
• Count of macrolanguage codes not in ISO 639-2: 3
  Query: SELECT COUNT(*) as count FROM ISO_639_3 LEFT JOIN ISO_639_2 USING (Id) WHERE ISO_639_2.Part2B IS NULL AND Scope='M'

  Alpha3	English Name
  hbs	Serbo-Croatian
  kln	Kalenjin
  luy	Luyia

• Count of macrolanguage codes not in ISO 639-1: 28
  Query: SELECT COUNT(*) as count FROM ISO_639_3 LEFT JOIN ISO_639_2 USING (Id) WHERE (ISO_639_2.Part2B IS NULL OR ISO_639_2.Part1 = '') AND Scope='M'