【MySQL篇】基本查询实战OJ

insert into actor values (1,'PENELOPE','GUINESS','2006-02-15 12:34:33');
insert into actor values (2,'NICK','WAHLBERG','2006-02-15 12:34:33');

select distinct salary from salaries order by salary desc;

select * from employees order by hire_date desc limit 1;

select * from employees where hire_date=(select distinct hire_date from employees 
order by hire_date desc limit 1 offset 2);

select emp_no,count(emp_no) as t from salaries group by emp_no having t>15;

select Email from Person group by Email having count(Email)>1;

select name,population,area from World where area>=3000000 or population>=25000000;