In this MySQL challenge, your query
should return the names of the people
who are reported to (excluding null
values), the number of members
that
report to them, and the average age of
those members as an integer. The
rows should be ordered by the names
in alphabetical order Your output
should look like the following table.
Answers
Explanation:
Leaving out the somewhat ridiculous and sometimes shameful religious slant towards this question, you would think that the purpose of humans is to find ways to work cooperatively to maintain the earth and its resources so that all of us have clean water and air, comfortable housing and clothing, adequate healthcare, and equal opportunities for work and education, and amenities such as transportation, communication, entertainment, and recreation. We should be able to do all this without polluting or spoiling the earth, which is, of course, the mother of all of us.
this MySQL challenge, your query
should return the names of the people
who are reported to (excluding null
values), the number of members
that
report to them, and the average age of
those members as an integer. The
rows should be ordered by the names
in alphabetical order Your output
should look like the following table.