07-21-2009, 09:50 PM
|
#5 (permalink)
|
|
La Vida es Sueño
Join Date: Sep 2007
Location: Oldham
Posts: 2,280
Thanks: 90
|
Naturally! 
sql Code:
SELECT
`group`, `customer`,
(SELECT COUNT(`id`) FROM `results` WHERE `result` = 'Win' AND `customer` = `r`.`customer`) AS `wins`,
(SELECT COUNT(`id`) FROM `results` WHERE `result` = 'Lose' AND `customer` = `r`.`customer`) AS `losses`
FROM
`results` `r`
GROUP BY
`customer`
ORDER BY
`wins`
DESC
__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.
|
|
|