IPL 2008 Auction 1

List of players whom was bought from Indian Premier League 2008 Auction 1

@kaggle.sandragracenelson_ipl_2008_auction_1

Table List

1 table(8.51 KB)

Ipl2008 Auc1

@kaggle.sandragracenelson_ipl_2008_auction_1.ipl2008_auc1

8.51 KB
77 rows
8 columns

no No.	category Category	name Name	nationality Nationality	speciality Speciality	base_price_in_us_thousands Base Price(in US$ Thousands)	team Team	auctioned_price_in_us_thousands Auctioned Price(in US$ Thousands)
1	A	Shane Warne	Australia	Bowler	450	Rajasthan Royals	450
2	A	Mahendra Singh Dhoni	India	Wicketkeeper	400	Chennai Super Kings	1500
3	A	Adam Gilchrist	Australia	Wicket keeper	300	Deccan Chargers	700
4	A	Shoaib Akhtar	Pakistan	Bowler	250	Kolkata Knight Riders	425
5	A	Mahela Jayawardene	Sri Lanka	Batsman	250	Kings XI Punjab	475
6	A	Muttiah Muralitharan	Sri Lanka	Bowler	250	Chennai Super Kings	600
7	B	Anil Kumble	India	Bowler	250	Royal Challengers Bangalore	500
8	B	Glenn McGrath[REC]	Australia	Bowler	350	Delhi Daredevils	350
9	B	Mohammed Yousuf[REC]	Pakistan	Batsman	350	Unsold
10	B	Harbhajan Singh	India	Bowler	250	Mumbai Indians	850


CREATE TABLE ipl2008_auc1 (
  "no" BIGINT,
  "category" VARCHAR,
  "name" VARCHAR,
  "nationality" VARCHAR,
  "speciality" VARCHAR,
  "base_price_in_us_thousands" BIGINT,
  "team" VARCHAR,
  "auctioned_price_in_us_thousands" DOUBLE
);