|
Field |
Type |
Null |
Key |
Default |
Extra |
|
id |
int(11) |
NO |
PRI |
NULL |
auto_increment |
|
person_id |
int(11) |
YES |
|
NULL |
|
|
project |
varchar(255) |
YES |
|
NULL |
|
|
day |
int(11) |
YES |
|
NULL |
|
|
id |
person_id |
project |
day |
| 1 | 1 | T1 | 90 |
| 2 | 2 | T3 | 21 |
| 3 | 1 | T6 | 33 |
| 4 | 3 | T4 | 14 |
| 5 | 1 | T2 | 12 |
| 6 | 4 | T2 | 48 |
| 7 | 2 | T5 | 62 |
| 8 | 4 | T6 | 19 |
| 9 | 3 | T2 | 206 |
| 10 | 5 | T1 | 183 |
| 11 | 2 | T4 | 38 |
| 12 | 5 | T3 | 91 |
select person_id,sum(day) from info where day >=90 group by person_id having count(*) >= 2 order by sum(day) desc;
select person_id,sum(day) from info where day >=90 group by person_id having count(*) >= 1 order by sum(day) desc;
select person_id,sum(day) from info where day >=90 group by person_id having sum(day) >= 180 order by sum(day) desc;
select person_id,sum(day) from info where person_id in (select distinct(person_id) from info where day >= 90) group by person_id having count(*) >= 2 order by sum(day) desc;
