SQL Script:

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

In SQL:

-Create a list of car details for cars that were made by car makers in Germany.

- Use a minimum of two nested subqueries to minimize the number of joints that is needed

- Display the out year & the year model as one field called Model and display the MPG, Cylinders, & Horsepowers as one field, each column separated by '-' called Specs.

-Order by year

Example of what it should look like:

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 MODEL 1970 audi 1970 volkswagen 1970 bmw 1971 volkswagen 1971 opel 1971 volkswagen 1972 volkswagen 1972 volkswagen 973 volkswagen SPECS 24-4-90 26-4-46 26-4-113 -4-48 28-4-90 27-4-60 23-4-54 22-4-76 26-4-46 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 MODEL 1970 audi 1970 volkswagen 1970 bmw 1971 volkswagen 1971 opel 1971 volkswagen 1972 volkswagen 1972 volkswagen 973 volkswagen SPECS 24-4-90 26-4-46 26-4-113 -4-48 28-4-90 27-4-60 23-4-54 22-4-76 26-4-46