B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
Suppose I have a table:

Create table "yearofbirth INTEGER, Name string"

What will be the query to identify how many people were born in
different years? The output should contain all the years that are
present in the table and the total count corresponding to each entry.

One can use GROUP BY.

You forgot to mention the email address of your professor, so I could send your homework assignment directly to him or her.

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to