W3schools.com Create SQL, below is the question.

question 4 (60 points) chrone use https://www.w3schools.com/sal/ to complete the f used for each query (no need to submit the query results). 4.1 Which salesman (i.e. employee) produces the largest amount of sales? Write a query to answer this question (10 points) 4.2 What supplier appears to be the most important (in terms of revenue generation)? Write a query t answer this question (10 points). 4.3 How much revenue for each product category does each shipper handle? Write a query to answer this question (10 points). 4.4 What customer purchases the most seafood (in terms of revenue)? Write a query to answer the question (10 points). 4.5 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 (u values "Buys seafood" and "Does not buy seafood"). Sort the report so that customers that buy seafo appear from largest total revenue to smallest total revenue, while customer that do not buy seafood sorted alphabetically by their names (20 points). Case 3times