也是有两种解法

sql
create table Person(
    id int primary key,
    email varchar(20)
) ;

show tables;

解法一：临时表

SQL
create table weather(
    id int primary key ,
    recordData date ,
    temperature int
);

show tables;

select * from weather;

insert into weather values (1,'2015-01-01',10),(2,'2015-01-02',25),(3,'2015-01-03',20),(4,'2015-01-04',30);

select a.id 
from weather as a,weather as b 
where a.temperature > b.temperature 
and datediff(a.recordData,b.recordData) = 1;

解法二:自连接

sql
select a.id 
from weather as a join weather as b 
on datediff(a.recordData,b.recordData) = 1 
where a.temperature > b.temperature ;

When I’m lost in Chinese cities I stop a taxi and give them my destination written on a piece of paper (in Chinese characters, supplied by a friend or hotel staff). Taxis are relatively cheap in China.

• When：当。
• I’m lost：我迷路了。
• in Chinese cities：在中国的城市。
• I stop a taxi：我拦下一辆出租车。
• and give them：并给他们。
• my destination：我的目的地。
• written on a piece of paper：写在一张纸上。
• in Chinese characters：用中文字符。
• supplied by a friend：由朋友提供。
• or hotel staff：或酒店工作人员。
• Taxis are：出租车相对。
• relatively cheap：相对便宜。
• in China：在中国。