How to join tables with text column : I got 2 tables to merge

t1
Continent    Country     City
-----------------------
Europe      Germany      Munich

NA          Canada       Ontario

Asia        Singapore    (blank)

Asia        Japan        Tokyo


AND


t2
Country      Status
-----------------
Germany      Complete

Canada       Incomplete

Singapore    Complete

Japan        Complete

I want to get the continent with 2nd highest "complete", what should I do? I am new to SQL and is trying hard to learn the basics but I cannot get this done.

Thanks all
