SQL Script:

https://docs.google.com/document/d/1GGLqg0_6fa_YzMqGKznCVq6f1M0egdB5vVl_8kyY4ac/edit?usp=sharing

In SQL:

-Create a breakdown of the marketshare for each of the car manufacturers using a percentage

- Equation I would used is Total # of cars manufactured by a maker / total # of cars produced * 100

- You need to know the total # of cars produced by each maker and the total # of cars produced overall.

- Order results by Marker Share in Descending order & Display the model name with the first letter capitalized.

It should look like this:

CARS CONTINENTS PK CONTID CONTINENT varchar2(15) CARS.CAR MAKERS CARS.COUNTRIES CARS.MODEL DETAILS PK MODELID number FKI MAKER | number PK ID PK COUNTRYID have /from MAKER FULLNAME varchar2(25) FK CONTINENT number PKAK|MODEL |varchar2(25) FK COUNTRYnumber are for CARS.CAR DETAILS PK,FK ID MPG CYLINDERS number EDISPL HORSEPOWERnumber WEIGHT ACCEL YEAR CARS.CAR NAMES PK ID number FK MODEL varchar2(25) DESCRvarchar2(40) number number %,Market 13.05 11.82 7.88 7.14 6.90 6.40 Model Ford Chevrolet Plymouth Amc Dodge Toyota Volkswagen5.67 Datsun Buick 5.67 4.19 CARS CONTINENTS PK CONTID CONTINENT varchar2(15) CARS.CAR MAKERS CARS.COUNTRIES CARS.MODEL DETAILS PK MODELID number FKI MAKER | number PK ID PK COUNTRYID have /from MAKER FULLNAME varchar2(25) FK CONTINENT number PKAK|MODEL |varchar2(25) FK COUNTRYnumber are for CARS.CAR DETAILS PK,FK ID MPG CYLINDERS number EDISPL HORSEPOWERnumber WEIGHT ACCEL YEAR CARS.CAR NAMES PK ID number FK MODEL varchar2(25) DESCRvarchar2(40) number number %,Market 13.05 11.82 7.88 7.14 6.90 6.40 Model Ford Chevrolet Plymouth Amc Dodge Toyota Volkswagen5.67 Datsun Buick 5.67 4.19