-- Check the column definition
SHOW COLUMNS FROM users LIKE 'userType';

-- Check for any empty or NULL values (should return 0)
SELECT COUNT(*) as empty_or_null_count FROM users WHERE userType = '' OR userType IS NULL;

-- Show distinct userType values and their counts
SELECT userType, COUNT(*) as count FROM users GROUP BY userType;