管理Oracle数据库。Jack负责管理“销售”部门。他和他的雇员经常需要查询数据库以确定客户及其订单。他要求您创建一个

CREATE VIEW sales_view AS（SELECT companyname，city，orderid，orderdate，total FROM customers，orders WHERE custid=custid}WITHREAD ONLY

CREATE VIEW sales_view（SELECT c.companyname，c.city，o.orderid，o.orderdate，o.tota lFROM customersc，orderso WHERE c.custid=o.custid}WITHREAD ONLY

CREATE VIEW sales_view AS（SELECT c.companyname，c.city，o.orderid，o.orderdate，o.total FROM customersc，orderso WHERE c.custid=o.custid}

CREATE VIEW sales_view AS（SELECT c.companyname，c.city，o.orderid，o.orderdate，o.total FROM customersc，orderso WHERE c.custid=o.custid）WITHREAD ONLY