SQL Introduction Mystery Cache

My job as a DBA/Systems Admin requires a lot of customer interaction and requests for data analysis and reports.  

Welcome to my worklife!

Who said you can't combine work with play?

This is a basic introduction to SQL and if liked a first in a short series.  Consider if you will the following table named CacherStats.  I've selected some fellow cachers at random from find logs on my caches.

You will need to understand only a few basics to get the coordinates to the cache.

Here is the format

N ab° cd.efg′    W hij° k.lmn′

The puzzle is as follows:

a: Select Count(*) from CacherStats Where BestDay >= 500
b: Select Slump from CacherStats Where Hides = 77 and TBsOwned = 63
c: Select Hides from CacherStats Where BestDay = 20
d: Select Location from CacherStats Where Joined = '12/11/2011'
e: Select sum(Streak) from CacherStats Where (Loaction is NULL and BestDay = 1) or Slump > 1200
f: Select Count(*) as Oldies from CacherStats Where Joined < '6/1/2008'
g: Select Count(*) as Newbs from CacherStats Where Joined > '6/1/2014'

h: Select Hides from CacherStats Where CachingName like '%efi%'
i: Select TBsOwned from CacherStats Where Streak > 1000 and Streak < 1013
j: Select Finds from CacherStats Where Trackables is NULL
k: Select Hides from CacherStats Where Finds > 3730 and Streak < 50
l: Select Count(*) from CacherStats Where Location is NULL and Finds > 3500
m: Select Count(*) from CacherStats Where LastSeen != '8/31/2015'
n: Select sum(Hides) from CacherStats Where Slump = 315 or BestDay = 50

As always, have fun and if you get stuck on any part of this just send me a message and I'll get back to you soon.

Congratulations to ShipFam2000 and Xander&Mommy for their Co-FTF and first FTFs!!!