Mercedes Used Car Listing

how much my friend should sell his old Mercedes

@kaggle.mysarahmadbhat_mercedes_used_car_listing

Table List

1 table(158.55 KB)

Merc

@kaggle.mysarahmadbhat_mercedes_used_car_listing.merc

158.55 KB
13119 rows
9 columns

model Model	year Year	price Price	transmission Transmission	mileage Mileage	fueltype FuelType	tax Tax	mpg Mpg	enginesize EngineSize
SLK	2005	5200	Automatic	63000	Petrol	325	32.1	1.8
S Class	2017	34948	Automatic	27000	Hybrid	20	61.4	2.1
SL CLASS	2016	49948	Automatic	6200	Petrol	555	28	5.5
G Class	2016	61948	Automatic	16000	Petrol	325	30.4	4
G Class	2016	73948	Automatic	4000	Petrol	325	30.1	4
SL CLASS	2011	149948	Automatic	3000	Petrol	570	21.4	6.2
GLE Class	2018	30948	Automatic	16000	Diesel	145	47.9	2.1
S Class	2012	10948	Automatic	107000	Petrol	265	36.7	3.5
G Class	2019	139948	Automatic	12000	Petrol	145	21.4	4
GLA Class	2017	19750	Automatic	15258	Diesel	30	64.2	2.1


CREATE TABLE merc (
  "model" VARCHAR,
  "year" BIGINT,
  "price" BIGINT,
  "transmission" VARCHAR,
  "mileage" BIGINT,
  "fueltype" VARCHAR,
  "tax" BIGINT,
  "mpg" DOUBLE,
  "enginesize" DOUBLE
);