do query decomposition on the following 5 queries:

do query decomposition on the following 5 queries:
/************************************************************
* CREATE VIEW TO COUNT DEALERSHIP NUMBER IN EACH STATE
************************************************************/

CREATE OR REPLACE VIEW ZIPCODE_COUNT AS SELECT STATE, COUNT(*) AS “NUMBER” FROM
ZIP_CODE GROUP BY STATE ORDER BY “NUMBER”;

SELECT * FROM ZIPCODE_COUNT;

/************************************************************
* CREATE VIEW FOR ALL CARS
************************************************************/

CREATE OR REPLACE VIEW ALL_CAR AS SELECT MAKE, MODEL, YEAR,
MILEAGE, COLOR_NAME FROM CAR JOIN COLOR USING(COLOR_ID);

SELECT * FROM ALL_CAR;

/************************************************************
* CREATE VIEW FOR BLACK CARS ONLY
************************************************************/

CREATE OR REPLACE VIEW BLACK_COLOR_VEHICLE AS SELECT MAKE, MODEL, YEAR,
MILEAGE FROM CAR WHERE CAR.COLOR_ID = (SELECT COLOR_ID
FROM COLOR WHERE COLOR_NAME = ‘BLACK’);

SELECT * FROM BLACK_COLOR_VEHICLE;

/************************************************************
* CREATE VIEW FOR DEALERSHIP LOCATION
************************************************************/

CREATE OR REPLACE VIEW DEALERSHIP_LOCATION AS
SELECT * FROM DEALERSHIP JOIN ZIP_CODE USING (ZIP);

SELECT * FROM DEALERSHIP_LOCATION;

/************************************************************
* CREATE VIEW FOR DEALERSHIP CARS
************************************************************/

CREATE OR REPLACE VIEW CAR_SALES AS
SELECT * FROM DEALERSHIP_CAR JOIN CAR USING (CAR_ID);

S

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"