In this week’s puzzle we are going to try to figure out how many uppercase, how many lowercase characters are in a column, we are also interested in how many are neither uppercase or lowercase

Here is the table and the data

CREATE TABLE Puzzle
     (Col1 varchar(10));
 
INSERT INTO Puzzle (Col1)
SELECT 'ABCD01234Z'
UNION ALL
SELECT 'AAAAAAAAAA'
UNION ALL
SELECT 'aaaaaaaaaZ'
UNION ALL
SELECT 'a&a&a&a&aA'
UNION ALL
SELECT '1234Tt7890'

This is the expected output

Col1       UpperCase   LowerCase   Neither
ABCD01234Z  5       0       5
AAAAAAAAAA  10      0       0
aaaaaaaaaZ  1       9       0
a&a&a&a&aA  1       5       4
1234Tt7890  1       1       8

For bonus points, you can add 3 more columns to the output, one column will hold only uppercase characters, one column will hold only lowercase characters, one column will hold only characters that are neither uppercase or lowercase