SQLize Online / PHPize Online  /  SQLtest Online

create table test (code char(10), data char(100), rank char(1), rate integer); Insert into test (code, data, rank, rate) values( 'first', 'it is first', 's', 10 ); Insert into test (code, data, rank, rate) values( 'second', 'it is second', 's', 3 ); Insert into test (code, data, rank, rate) values( 'third', 'it is third', 't', 7 ); Insert into test (code, data, rank, rate) values( 'forth', 'it is forth', 't', 2 ); Insert into test (code, data, rank, rate) values( 'fifth', 'it is fifth', 't', 1 ); select * from test; select z.* from( select rank, sum(rate) as summ, avg(rate) as average, min(rate) as minimum, max(rate) as maximum from test where rate > 3 group by rank ) as z where summ > 7; select rank, sum(rate) as summ, avg(rate) as average, min(rate) as minimum, max(rate) as maximum from test where rate > 3 group by rank having rank = 't'; drop table test;