By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| COUNT(AGE) |
|---|
| 3 |
| AGETEST |
|---|
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| (SELECTCOUNT(AGE)FROMPERSONSWHEREAGE>100) |
|---|
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| AGETEST |
|---|
| 3 |
| COUNTGREATERTHAN100(AGE) |
|---|
| 3 |
8 rows affected
| COUNT(AGE) |
|---|
| 3 |
| AGETEST |
|---|
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| (SELECTCOUNT(AGE)FROMPERSONSWHEREAGE>100) |
|---|
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| 3 |
| AGETEST |
|---|
| 3 |
| COUNTGREATERTHAN100(AGE) |
|---|
| 3 |