GC62MW9 SQL Introduction
Type: Mystery | Size: Micro | Difficulty: | Terrain:
By: RPieperCO @ | Hide Date: 08/31/2015 | Status: Available
Country: United States | State: Colorado
Coordinates: N38° 50.394 W104° 43.313 | Last updated: 08/30/2019 | Fav points: 0
                       

---

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!!!

 

Additional Waypoints

08/19/2018 By NanCycle
The entire area is now a construction project with No Trespassing signs. The nearest tree is 100 ft from GZ.

06/20/2018 By RPieperCO
Yup... original is gone. Replaced at the base of tree under a few rocks. Good to go.

05/02/2018 By kkcjrlma
Solved the puzzle just before traveling out here, but came up with nothing at gz.

03/20/2018 By CDRSheppo
I found it with my mommy, thanks for the puzzle!

03/20/2018 By shelleah
I found this during some downtime with the baby as I continue the Planetary Pursuit. I solved this fun puzzle on 9/4/17. I was looking in the completely wrong direction at GZ and finally spotted it. The log was damp but I was able to sign it. Thanks for the puzzle!