SEDSAT Database Query

SEDSAT Database Definition:

create table telemetry (
  Time           datetime,
  MainVoltage    int,
  MainCurrent    int,
  AmpsInBat      int,
  SolarPanel0    mediumint,
  SolarPanel1    mediumint,
  SolarPanel2    mediumint,
  SolarPanel3    mediumint,
  SolarPanel4    mediumint,
  Battery1       tinyint,
  Battery2       tinyint,
  CDS_DCDC       tinyint,
  MODEL_DCDC     tinyint,
  EMP            tinyint,
  MB_DCDC        tinyint,
  Deployer1      tinyint,
  Deployer2      tinyint,
  MODEL_PA       tinyint,
  CDSBoot        tinyint,
  SeasisBoot     tinyint,
  Images         tinyint,
  ResetCount     tinyint,
  MODEL          bit,
  MODEA          bit,
  SEASIS         bit,
  CAMERAS        bit,
  ANTDEPLOYER    bit,
  PANEL          bit,
  Updays	 mediumint,
  Uphours	 time,

  Callsign       char(8),
  UTC            tinyint,
  Created	 datetime,
  Lastmod	 timestamp(14),
  SourceFile	 varchar(255),
  SGSVersion	 varchar(8)
)

create table observer (
  Callsign   char(8),
  Name       char(64),
  UTCoff     tinyint,
  Email      char(64),
  Location   char(64),
  Lastmod	 timestamp(14)
)