|
| Имя: | Дьего Ривейро | | Страна: |  Уругвай | | Город: | | | Возраст: | | | Строгость: | строгий | | Доп. инфо: | часто ставит пенальти, часто дает вторую желтую, часто дает прямую красную |
Query:
select games, yellows, two_yellows, reds, pens,
tournament, t.name as tour_name, round(yellows/games+0.000001, 2) as avg_yellows,
round((yellows+2*reds)/games+0.000001, 2) as avg_cards
from referee_statistics, tournaments t
where referee = 2795 and t.id = tournament and tournament != 1 and tournament != 5
error: Can't open file: './fb/referee_statistics.frm' (errno: 24) |
