I'm working on building my knowledge base with tables.
If I make two tables Person and Capital as follows using SQL:
Person (id integer, first char(20), last char(20), address char(50),
city char(30), state char(2), zip char(5))
Capital (state char(2), city char(30)
How could I create a list such that last names that start with ‘AB’, and is a list of last names only?
OR make a list such that all states and number of persons from Person table.
OR make one that list all people who live in the capital of their state?