07-21-2009, 08:51 PM
|
#3 (permalink)
|
|
La Vida es Sueño
Join Date: Sep 2007
Location: Oldham
Posts: 2,280
Thanks: 90
|
Building onto Village Idiot's example:
sql Code:
SELECT
`customer` AS `customer_id`, `group`, `customer`,
(SELECT COUNT(`id`) FROM `results` WHERE `result` = 'Win' AND `customer` = `customer_id`) AS `wins`,
(SELECT COUNT(`id`) FROM `results` WHERE `result` = 'Lose' AND `customer` = `customer_id`) AS `losses`
FROM
`results`
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.
|
|
|