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

• Working file found here: User:FltAdml. Wolf/Awards '07 Project - Cleanup file.
• View the sample 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 - DONE, and ONLINE!

PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE

---

cochrane,Lt. Cmdr.,Stephen Carmody,USS Ursa Major,2007 
sextant,Ens., Alex Swift,USS Challenger,2007
phoenix,Lt. JG.,Seph 647,USS Constitution,2007 
prantares,Lt. Cmdr., Julia Harden,StarBase 118 Ops,2007
yar,Lt. JG.,Tal Tel-ar,USS Constitution,2007 
voyager,Lt. Cmdr.,Toni Turner,USS Challenger,2007 
valiant,Lt. Cmdr., Emirry MacGowan,USS Constitution,2007
sisko,Lt.,Rode Mitchell,Discovery-B,2007

---

Post General Awards Queries Below

PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE

---

---