# $1831. 每天的最大交易
# https://leetcode-cn.com/problems/maximum-transaction-each-day/

# SQL架构
Create table If Not Exists Transactions (transaction_id int, day datetime, amount int);
Truncate table Transactions;
insert into Transactions (transaction_id, day, amount) values ('8', '2021-4-3 15:57:28', '57');
insert into Transactions (transaction_id, day, amount) values ('9', '2021-4-28 08:47:25', '21');
insert into Transactions (transaction_id, day, amount) values ('1', '2021-4-29 13:28:30', '58');
insert into Transactions (transaction_id, day, amount) values ('5', '2021-4-28 16:39:59', '40');
insert into Transactions (transaction_id, day, amount) values ('6', '2021-4-29 23:39:28', '58');

# Write your MySQL query statement below
select
    transaction_id
from
    Transactions
where
    (date(day), amount) in (
        select
            dateday,
            maxamount
        from
            (
                select
                    date(day) as dateday,
                    max(amount) as maxamount
                from
                    Transactions
                group by
                    date(day)
            ) tmp
    )
order by
    transaction_id;

# clean-up
drop table Transactions;