SQL Group By Clause

     

    Copy Query and Syntax:

    Query: Provide the Avg Of Price Based on Item from Sales Table using Group By Clause
    Syntax: Select Item, avg(Price) as GroupByAvg from Sales Group By Item