4 Comments

    SELECT ProductID, ProductName, SupplierID, CategoryID, Unit, Price FROM Products where price>18 group by SupplierID, ProductId, ProductName,CategoryId,Unit,Price;

    select supplierid, count(productname) as Total_Products from products where price>18 group by supplierid;

    select productid, productname, supplierid, unit, price from products where price>18 group by productid, productname, supplierid, Unit, Price;

    select supplierid, count(CategoryID) as Total_CategoryID from products where price>18 group by supplierid;

Leave a Reply

Loading Questions

If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com