MYSQL 쿼리에 if 문 사용하기 예제

Select
ADate,
Sum(Amnt) As Total,
Sum(If(Pay = 1, Amnt, 0)) As Pay1,
Sum(If(Pay = 2, Amnt, 0)) As Pay2
From ATable
Group By ADate;