Create SQL view with all clients with the highest rating Cre

Create SQL view with all clients with the highest rating.

Create SQL view with all venders per city.

Create SQL view with average and total of orders after the name of all venderos [name average total_orders]

Create SQL view with venders with multiple clients.

Cnum 2001 2002 2003 2004 2006 2008 2007 Cname Hoffman Giovanni Lili Grass Clemens Cisneros Pereira Customer City Rating 100 London 200 Rome 200 San Jose Berlin 300 100 London 300 San Jose 100 Roma Snum 1001 1003 1002 1002 1001 1007 1004

Solution

1) Create SQL view with all clients with the highest rating.

Here we can create view with order by keyword to get all client list with highest rating.

CREATE VIEW CLIENT_WITH_RATING_VIEW AS
SELECT Cname, Rating
FROM Customer ORDER BY Rating

2) Create SQL view with all venders per city.

Here we can create view with order by keyword to get all vendors list per city.

CREATE VIEW VENDOR_PER_CITY_VIEW AS
SELECT Snum, Sname
FROM Salespeople ORDER BY City