Provide a breakdown of the market share of each of the car manufacturers using a percentage. (HINT: total number of cars manufactured by a maker / total number of cars produced * 100) You need to know the total number of cars produced by each maker and the total number of cars produced overall. Order the results by market share in descending order. Display the model name with the first letter capitalized. modify the query to confirm that the percentages all add up to 100
AutoSave OFF I svje: Assignment 2_SP21 (1) - Compatibility Mode - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share Q Comments Verdana v 12 Ci ν Α Α' Aa V A V 21 T. AaBbCcDdE AaBbDdEe AaBbCcDdE AaBbCcDdi AaBbCcDc AaBbCcDc Heading 1 Heading 2 Heading 3 Paste B I U V ab X X Emphasis = No Spacing ALA Normal V Styles Pane Dictate Sensitivity V Cars ERD Tip: counries. continent = car_makers. country; car_makers. id = model_details. maker; model_details. model = car_names. model; car_names. id = car_details. id CARS. CONTINENTS PK CONTID number CONTINENT varchar2(15) associated with have / from CARS. COUNTRIES PK COUNTRYID number COUNTRYNAME varchar2(20) FK CONTINENT number CARS. CAR_MAKERS PK ID number MAKER varchar(15) FULLNAME varchar2(25) FK COUNTRY number have CARS. MODEL DETAILS PK MODELID number FK MAKER number PKAK MODEL varchar2(25) are for = CARS CAR DETAILS PK, FK ID number MPG number CYLINDERS number EDISPL number HORSEPOWER number WEIGHT number ACCEL number YEAR number CARS. CAR NAMES PK ID number FK MODEL varchar2125) DESCR varchar(40) have 1 Page 1 of 4 454 words * English (United States) O Focus + 131%