SQL: Avg function for calculating the age of a man and woman in different columns

Tags:
SQL
I would like to use avg function for calculating the age of a man and woman in different columns but as a total in each case. Could you help me" For instance,
Select

Sum(case when woman then '1' else '0')woman

Sum(case when men then '1' else '0')men

Avg(birthday woman)avg1

Avg(birthday men)avg2


Software/Hardware used:
sql teradata
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: