People who moved from Blah City, Blah State:
Name Location Date Kids
Jack LA 02/05/1999 0
Cindy Chicago 12/15/2005 2
Randy LA 06/19/2003 3
Jason Seattle 04/06/2002 0
1. Who moved to LA?
SELECT Name, Location FROM MyTable ORDER BY Location;
LA Jack, Randy
What I got:
2. Who has the most kids?
SELECT Max(Kids) AS MostKids FROM MyTable;
Note: Not sure how to 'navigate' columns
3. WHo moved Before 2003
SELECT Name FROM MyTable WHERE Date<='1/1/2003';
Note: The date is in fact of data type Date/Time. Do i need to enclose the date in quotes?