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

T-SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
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'
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