Let's dig into our database. This database has 9 columns:

1. model - model of the car

2. year - year of manufacture

3. price - car price in Euros

4. transmission - type of gearbox

5. mileage - miles drove

6. fueltype - engine fuel type

7. tax - road tax

8. mpg - miles per gallon

9. enginesize - engine size in liters.

To extract certain columns you need to select them by their names, like:

Please note, that SQL is also case-insensitive to column names, i.e. if the column has name id both notations id and ID will be interpreted the same.