s Maings Review View HelpO Tell me what you want to do ISQL Advanced SQL ORACLE SQL statements outputs Cars ERD Tip: counries.continent-car makers.country; car_makers.id -model details.mak car names.model; car_names.id car_details.icd makers.id - model. details.maker; model. details.model PK CONTID 15) CARS CAR MAKERS CARS have/ from PK ID PK MODELID number PK COUNTRYID FULLNAME varchar2(25) FK | COUNTRY |ruber FK are for CARS CAR DETAILS PK,FK ID CARS.CAR NAMES CYLINDERS number EDISPL have FK | MODEL |varchar2(25) DESCR varchar2440) WEIGHT ACCEL YEAR Tools Vie 4. Provide a breakdown of the market share of each of the 5. For each country, list the country id, c ountry name, conti- car manufacturers using a percentage. (HINT: total num- ber 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 de- scending order. Display the model name with the first let- ter capitalized. nent name and the number of cars produced by each country. Order the results by car count in descending or- der. C Japan Germany France Sweden euope 39 Uk Nigeria Egypt Australia Ford 10 13 11.82 7.83 austraia0 6.90 6.40 Volkswagen 567 5.67 4.19 194 BONUS: Which country produces the most number of cars? To answer this question consider the following nested aggre- gate function: +5 BONUS-modify the query to confirm that the percentages all add up to 100 + 2 pts If you run the following, it will return a the total number of cars grouped by country. select c.countryid, (count (cn.id)) as carscount in 0.00 seconds from car names cn, countries c