619. Biggest Single Number.md

619. Biggest Single Number

Question Link

where & from, from need alias name!

Code1

# Write your MySQL query statement below
select max(num) num from MyNumbers
where num in (
  select num from MyNumbers group by num having count(num)=1
)

ATTENTION: alias name is optional

Code2

# Write your MySQL query statement below
select max(num) num from (
  select num from MyNumbers group by num having count(num)=1
) new_name

ATTENTION: alias name is must here!