by using www.w3schools.com write this SQL queries Write a query that outputs the customer name, total revenue for the customer, and an attribute called type that labels customers according to whether or not they have ever purchased seafood (use values Buys seafood and Does not buy seafood). Sort the report so that customers that buy seafood appear from largest total revenue to smallest total revenue, while customer that do not buy seafood are sorted alphabetically by their names .

Suppliers SupplierID SupplierName Products ProductID ProductName OrderDetails rderDetailID OrderID ProductID Quantity ID ID CustomerID upplierID CategoryID Unit Price stName City oyeeID Date ShipperID Photo otes ustomers Customer ID hiopers stomerName pperID ShipperName ContactName dress City lCode untry Categories Category CategoryName ID Suppliers SupplierID SupplierName Products ProductID ProductName OrderDetails rderDetailID OrderID ProductID Quantity ID ID CustomerID upplierID CategoryID Unit Price stName City oyeeID Date ShipperID Photo otes ustomers Customer ID hiopers stomerName pperID ShipperName ContactName dress City lCode untry Categories Category CategoryName ID