'Count values in column that have only letters

How Can I count rows in column where values have only letters ? For exmaple if I have this table:

| ID | Age | FULL_NAME |
|:---- |:------:| -----:|
| 0  | 23    | Jason12 |
| 1  | 11    | SamOG. |
| 2  | 57    | Alexx |

And when I run the query i want to get something like this:

| Numerator | Denominator | 
|:---- |:------:| 
| 1  | 3    |

Numerator are the rows where value is only build with letters and Denominator is count(*). Let's say that my DB name is CUSTOMERS. I use Teradata SQL Assistant. Any ideas how I can do it ? Any help would be greatly appreciated!

sqlteradata


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions