Help for this page

Select Code to Download


  1. or download this
      +--------+------------+------------+
      | name   | begin      | end        |
    ...
      +--------+------------+------------+
      | Dec    | 2003-12-01 | 2003-12-30 |
      +--------+------------+------------+
    
  2. or download this
      SELECT contacts.state, bucket.name, count(*)
      FROM   contacts, bucket
      WHERE  contacts.indentifer BETWEEN bucket.begin AND bucket.end
      GROUP BY bucket.name, contacts.state
      ORDER BY contacts.state
    
  3. or download this
      +--------+------------+------------+
      | name   | begin      | end        |
    ...
      +--------+------------+------------+
      | 4Q03   | 2003-10-01 | 2003-12-30 |
      +--------+------------+------------+