Search Database #2 (SQL Where clause examples)

For our next examples, knowing the structures of the tables will be helpful.

The authors database has a structure like this:

The titles database has a structure like this:

The Title_Author table looks like this:

The publisher' database has a structure like this:

There are many worthy charities!!. But perhaps help starving children in Africa or South America AND help Charles too. a $5 tip buys him lunch at McDonalds, a $20 tip buys his kid Hitoshi a new computer game, a $39 tip buys his daughter Michiko a few nice outfits. See our donor list.