User:FltAdml. Wolf/Awards '07 Project - SQL File

View the sample file for more help.

List of Awards Names

Duty Post Awards

• strange = First Officer: The Strange Medallion
• cochrane = Science: The Cochrane Award
• sextant = Helm: The Pilot's Sextant
• phoenix = Engineering: The Phoenix Award
• prantares = Medical: The Prantares Ribbon
• yar = Security: The Natasha Yar Pin
• voyager = Operations: The Voyager Medallion
• valiant = Counseling: The Order of the Valiant Heart
• sisko = Tactical: Captain Sisko Tactical Cross

General Awards

• barclay = The Barclay Bead
• bplot = B-Plot Award
• kalendra = The Kalendra Award
• merria = The Merria Medallion
• nebula = The Nebula Bar
• neelix = The Neelix Award
• purplestar = The Purple Star
• sarpeidon = Sarpeidon Award
• scotty = The Scotty Cross
• sheathed = The Sheathed Sword
• silver = The Silver Palm
• TOSMA1 = The Order of StarFleet Merit and Achievement First Class (TOSMA I)
• TOSMA2 = The Order of StarFleet Merit and Achievement Second Class (TOSMA II)
• xalor = The Xalor Clan Xifilis Award
• data = Data Artistic Award

The query

Format

[Award Code],[Rank Abbreviation w/period],[Character Name],[Ship],2007

Example

• General: barclay,Lt. Cmdr.,John Graves,USS Triumphant,2006
• Duty Post: sisko,Lt.,Rode Mitchell,Ops,2005

Post Duty Post Queries Below

PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE

---

---

Post General Awards Queries Below

PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE

---

---