Select query with gourp By : I need  to select the table values with (group by) options. Table1  contains the list of week data I need to sum and group the values based on the Desc 2,  Please help


**Table1:**

    ╔════════╦═══════╦════════╦═══════╗
    ║     ID ║ Desc  ║ Desc 2 ║  Amt  ║
    ╠════════╬═══════╬════════╬═══════╣
    ║      1 ║ Total ║ Spent  ║ 25.00 ║
    ║      2 ║ Total ║ Net    ║ 55.00 ║
    ║      3 ║ Total ║ Spent  ║ 78.00 ║
    ║      4 ║ Total ║ avg    ║ 99.00 ║
    ║      5 ║ Total ║ Net    ║ 54.00 ║
    ║      6 ║ Total ║  vv    ║ 58.00 ║
    ║      7 ║ Total ║  vv    ║ 55.00 ║ 
    ║      8 ║ Total ║ avg    ║ 55.00 ║ 
    ╚════════╩═══════╩════════╩═══════╝

I need a select query as below from the tabel1

  **Result Tabel:**

    ╔════════╦═══════╦════════╦═══════╗
    ║     ID ║ Desc  ║ Desc 2 ║  Amt  ║
    ╠════════╬═══════╬════════╬═══════╣
    ║      1 ║ Total ║ Null   ║479.00 ║
    ║      2 ║ Total ║ Net    ║109.00 ║
    ║      3 ║ Total ║ Spent  ║103.00 ║
    ║      4 ║ Total ║ avg    ║154.00 ║
    ║      5 ║ Total ║ vv     ║113.00 ║
    ╚════════╩═══════╩════════╩═══════╝