SELECTing certain columns

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.