# $619. 只出现一次的最大数字
# https://leetcode-cn.com/problems/biggest-single-number/

# SQL架构
Create table If Not Exists MyNumbers (num int);
Truncate table MyNumbers;
insert into MyNumbers (num) values ('8');
insert into MyNumbers (num) values ('8');
insert into MyNumbers (num) values ('3');
insert into MyNumbers (num) values ('3');
insert into MyNumbers (num) values ('1');
insert into MyNumbers (num) values ('4');
insert into MyNumbers (num) values ('5');
insert into MyNumbers (num) values ('6');

# Write your MySQL query statement below
select
    (
        select
            num
        from
            MyNumbers
        group by
            num
        having
            count(num) = 1
        order by
            num desc
        limit
            1
    ) as num;

# clean-up
drop table MyNumbers;