+----+--------+----------+------------+--------+
| id | tipper | spieltag | anz_tipper | gewinn |
+----+--------+----------+------------+--------+
|  1 | Test   |        1 |         10 |   5.00 |
|  2 | Test2  |        1 |         10 |   5.00 |
|  3 | Test3  |        1 |         10 |   5.00 |
|  4 | Test2  |        2 |         10 |   7.50 |
|  5 | Test3  |        2 |         10 |   7.50 |
+----+--------+----------+------------+--------+

1. Test2    2    1 (10), 2 (10)    12.50
   Test3    2    1 (10), 2 (10)    12.50
3. Test     1    1 (10)             5.00

select tipper,count(spieltag) as wochensiege,anz_tipper,sum(gewinn) as gewinn from tippliga_wochengewinner group by tipper order by gewinn desc;
+--------+-------------+------------+--------+
| tipper | wochensiege | anz_tipper | gewinn |
+--------+-------------+------------+--------+
| Test2  |           2 |         10 |  12.50 |
| Test3  |           2 |         10 |  12.50 |
| Test   |           1 |         10 |   5.00 |
+--------+-------------+------------+--------+

Tipper    Anzahl Wochensiege     Gewinn

Tipper    Anzahl Wochensiege     Spieltag      Anzahl der Tipper insg. bei diesem Spieltag       Gewinn

SELECT 
       a.tipper,a.count(spieltag) as wochensiege,
       a.anz_tipper,a.sum(gewinn) as gewinn,
 { hier dein anderer code von der zweiten abfrage zwischen SELECT und FROM }
 
FROM
         tippliga_wochengewinner a
INNER JOIN 
         tippliga_wochengewinner b ON 
         a.tipper = b.tipper
GROUP BY
        a.tipper 
ORDER BY 
       a.gewinn DESC;

+--------+----------+------------+--------+
| tipper | spieltag | anz_tipper | gewinn |
+--------+----------+------------+--------+
| Test   |        1 |          3 |   7.75 |
| Test2  |        1 |          3 |   7.75 |
| Test   |        2 |          3 |   7.75 |
| bla    |        2 |          3 |   7.75 |
+--------+----------+------------+--------+

select a.tipper,count(a.spieltag) as wochensiege,a.anz_tipper,sum(a.gewinn) as gewinn from tippliga_wochengewinner a inner join tippliga_wochengewinner b on a.tipper = b.tipper group by a.tipper order by gewinn desc;

+--------+-------------+------------+--------+
| tipper | wochensiege | anz_tipper | gewinn |
+--------+-------------+------------+--------+
| Test   |           4 |          3 |  31.00 |
| bla    |           1 |          3 |   7.75 |
| Test2  |           1 |          3 |   7.75 |
+--------+-------------+------------+--------+

SELECT
      id,tipper,count(spieltag) as wochensiege,
      anz_tipper,sum(gewinn) as gewinn
FROM 
      tippliga_wochengewinner
GROUP BY
      tipper
ORDER BY
      gewinn desc;

SELECT
      ID,TIPPER, SAISON,SPIELTAG,ANZ_TIPPER,
      sum(gewinn) as gewinn
FROM
      tippliga_wochengewinner
WHERE
      TIPPER = '$tipper'
GROUP BY
      TIPPER,SPIELTAG
ORDER BY 
      SPIELTAG DESC;

CREATE TABLE `tippliga_wochengewinner` (
  `ID` int(13) NOT NULL auto_increment,
  `TIPPER` varchar(30) NOT NULL default '',
  `SPIELTAG` int(2) NOT NULL default '0',
  `ANZ_TIPPER` int(3) NOT NULL default '0',
  `GEWINN` decimal(10,2) NOT NULL default '0.00',
  `SAISON` varchar(9) NOT NULL default '',
  `EINGETRAGEN` datetime NOT NULL default '0000-00-00 00:00:00',
  `DURCH` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;


INSERT INTO `tippliga_wochengewinner` VALUES (1, 'Test', 1, 3, 7.75, '2005-2006', '2005-07-04 17:34:43', 'Heart');
INSERT INTO `tippliga_wochengewinner` VALUES (2, 'Test2', 1, 3, 7.75, '2005-2006', '2005-07-04 17:34:43', 'Heart');
INSERT INTO `tippliga_wochengewinner` VALUES (3, 'Test', 2, 3, 7.75, '2005-2006', '2005-07-04 17:35:12', 'Heart');
INSERT INTO `tippliga_wochengewinner` VALUES (4, 'bla', 2, 3, 7.75, '2005-2006', '2005-07-04 17:35:12', 'Heart');

   SELECT
        a.id,
        a.tipper,
        COUNT(a.tipper) AS tippwochensiege_insg,
        SUM(a.gewinn) AS gewinn_insgesamt
   FROM
        tippliga_wochengewinner a
   GROUP BY
        a.tipper
   ORDER BY
        gewinn_insgesamt DESC

    SELECT
        a.spieltag,
        a.tipper,
        anz_tipper,
        SUM(a.gewinn) AS gewinn
    FROM
         tippliga_wochengewinner a
    WHERE
         a.tipper = 'test'
    GROUP BY
         a.spieltag