SQL Group By Clause

     

    Copy Query and Syntax:

    Query: Retrieve Count Records Apple Banana Grapes group by Item
    Syntax: Select Item,count(Price) from Sales where Item in('Apple', 'Banana', 'Grapes') Group by Item