Day22Hw - having been born in each State of the USA. [93]...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Create a query to list (in reverse chronological order) the earliest birthdate recorded in the db for each Country. [1027] ---- SELECT MIN(birthdate), country FROM births GROUP BY country ORDER BY birthdate DESC Create a query to list how many people in the database are recorded as
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: having been born in each State of the USA. [93] (Note: use "USA" for the country.)------SELECT COUNT(person_id)AS People, state FROM births WHERE country = "USA" GROUP BY state...
View Full Document

This note was uploaded on 12/14/2011 for the course CSE 101 taught by Professor Allusethis during the Fall '08 term at Michigan State University.

Ask a homework question - tutors are online