MySQL表组_MySQL Select中的组和子组表

我有一张表SalesInvoice。在此日期中，金额模式是此表中的重要列。

SNo BID iDate Amount Mode

----------------------------------------------------------------

101 1 2016-01-01 200 Cash

102 2 2016-01-01 500 Credit

103 5 2016-01-01 800 credit

104 8 2016-01-01 250 Cash

105 1 2016-01-01 200 Cash

106 2 2016-01-02 500 Cash

107 5 2016-01-03 800 Credit

108 8 2016-01-03 250 Credit我的必需输出是

iDate MinSno MaxSno Total CreditTotal CashTotal

----------------------------------------------------------------------

2016-01-01 101 105 1950 1300 650

2016-01-02 106 106 500 0 500

2016-01-03 107 108 1050 1050 0我尝试了MySQL Query

SELECT iDate, Min(SNo) AS MinSno, Max(SNo) AS MaxSno, SUM(Amount)

From SalesInvoice GROUP By iDate但是，我不知道如何根据主组iDate中的子组获得现金和信用额度总和。请帮助我，如何达到上述预期产出？