I need help with a simple Oracle script. It has to do with using Create View and Joining multiple tables. Please see attached file for more instructions. I need this done soon so please rush it if you can. Thanks.
As an addition, we were instructed that the code would look something like this,
CREATE VIEW supplier_10
AS SELECT p_num, quantity, supplier.city
FROM part_S JOIN supplier ON part_S.s_num=supplier.s_num
WHERE supplier.s_num=10;
SELECT p_num, quantity,city_S.city, stat…
