# $1459. 矩形面积
# https://leetcode-cn.com/problems/rectangles-area/

# SQL架构
Create table If Not Exists Points (id int, x_value int, y_value int);
Truncate table Points;
insert into Points (id, x_value, y_value) values ('1', '2', '7');
insert into Points (id, x_value, y_value) values ('2', '4', '8');
insert into Points (id, x_value, y_value) values ('3', '2', '10');

# Write your MySQL query statement below
select
    p1.id as p1,
    p2.id as p2,
    abs(p2.x_value - p1.x_value) * abs(p2.y_value - p1.y_value) as area
from
    Points p1
    inner join Points p2 on p1.id < p2.id
where
    (p2.x_value - p1.x_value) != 0
    and (p2.y_value - p1.y_value) != 0
order by
    area desc,
    p1.id,
    p2.id;

# clean-up
drop table Points;