provide an example query using both a group by clause and a having clause. Show no more than ten rows of your query result. Discuss if the query you wrote can be rewritten without those clauses.( you could use any heading field)

SQL SQL Administration SCHEMAS Q Filter objects customers new_table order_items Local instance 3306 orders PRODUCT products products1 productsss Functiona Object Info Table: products Views Stored Procedures Columns: product_id category_id product_code product_name description list_price Query Completed Schemas text Session int AI PK int varchar(10) varchar(255) decimal(10,2) discount_percent decimal(10,2) date_added datetime DO create_my_guitar_shop* 100% ZIRO 1. SELECT * FROM my_guitar_shop.products; Result Grid 123456 39:1 7 8 9 10 11 NULL product_id category_id product_code products 1 SQL File 7* 1 1 1 1 1 1 2 2 3 3 4 NULL Filter Rows: strat les_paul Search sg fg700s washburn rodriguez precision hofner ludwig tama dgx_640 NULL PRODUCT Limit to 1000 rows Edit: product_name products products Export/Import: Fender Stratocaster Gibson Les Paul Gibson SG Yamaha FG700S Washburn D10S Rodriguez Caballero 11 Fender Precision Hofner Icon Ludwig 5-piece Drum Set with Cymbals Tama 5-Piece Drum Set with Cymbals Yamaha DGX 640 88-key Digital Piano NULL 4 description list_price The Fender Stratocaster is the electric guitar de... 699.00 This Les Paul guitar offers a carved top and hu... 1199.00 This Gibson SG electric guitar takes the best of... 2517.00 The Yamaha FG700S solid top acoustic guitar h... 489.99 The Washburn D10S acoustic guitar is superbly... 299.00 Featuring a carefully chosen, solid Canadian ce... 415.00 The Fender Precision bass guitar delivers the s... 799.99 With authentic details inspired by the original, th... 499.99 This product includes a Ludwig 5-piece drum se... 699.99 The Tama 5-piece Drum Set is the most afforda... 799.99 Long description to come 799.99 NULL NULL discount_percent 30.00 30.00 52.00 38.00 0.00 39.00 30.00 25.00 30.00 15.00 0.00 NULL Apply Result Grid Form Editor A === Field Types Query Stats Revert Q Context Help Snippets I? KI? Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help.