STRUCTURED QUERY LANGUAGE(SQL) Created by: B Mokshagna Reddy (BMR) SQL DATA DEFINITION AND DATATYPES SQL Schema: An SQL schema is identified by a schema name and includes an authorization identifier name to indicate user or account who owns the schema, as well as descriptor for each elements in the schema. Schema creation with authorization: CREATE SCHEMA DATABASE_NAME AUTHORIZATION IDENTIFIER; Eg: CREATE SCHEMA COMPANY AUTHORIZATION ‘JSMITH’; Catalog: Named collection of schemas. Data Definition, Constraints, and Schema Changes Used to CREATE, DROP, and ALTER the descriptions of the tables (relations) of a database Creating a Database Syntax: CREATE DATABASE database_name; Creating a Table Syntax CREATE TABLE table_name (Column_name datatype[(size)], Column_name datatype[(size)], ); Specifies a new base relation by giving it a name, and specifying each of...
TATA IPL AUCTION 2023
Created by: B Mokshagna Reddy (BMR)
Total Players at the auction: 405
273 Indian Players
132 Overseas Players (of which 4 are from from Associate Nations)
Capped Players - 119
uncapped Players - 282
Total Purse remaining at the auction: 206.5 Cr
Slots to be Filled: 87 Slots
Team | Purse Left (in INR) | Available solts | Overseas Slots |
---|---|---|---|
CSK | 20.45 Cr | 7 | 2 |
DC | 19.45 Cr | 5 | 2 |
GT | 19.25 Cr | 7 | 3 |
KKR | 7.05 Cr | 11 | 3 |
LSG | 23.35 Cr | 10 | 4 |
MI | 20.55 Cr | 9 | 3 |
PBKS | 32.2 Cr | 9 | 3 |
RR | 13.2 Cr | 9 | 4 |
RCB | 8.75 Cr | 7 | 2 |
SRH | 42.25 Cr | 13 | 4 |
List of players bought by each frachise
CSK - Chennai Super Kings
1. Ajinkya Rahane - 50 Lakh2. Ben Strokes - 16.25 Crore
3. Shaik Rasheed - 20 Lakh
4. Nishant Sindhu - 60 Lakh
5. Kyle Jamieson - 1 Crore
6. Ajay Mandal - 20 Lakh
7. Bhagath Varma - 20 Lakh
DC - Delhi Capitals
1. Phil Salt - 2 Crore2. Ishant Sharma - 50 Lakh
3. Mukesh Kumar - 5.5 Crore
4. Manish Pandey - 2.4 Crore
5. Rilee Rossouw - 4.6 Crore
GT - Gujarat Titans
1. Kane Williamson - 2 Crore2. Odean Smith - 50 Lakh
3. KS Bharat - 1.2 Crore
4. Shivam Mavi - 6 Crore
5. Urvil Patel - 20 Lakh
6. Joshua Little - 4.4 Crore
7. Mohit Sharma - 50 Lakh
KKR - Kolkata Knight Riders
1. Ajinkya Rahane -2. N Jagadeesan - 90 Lakh
3. Vaibhav Arora - 60 Lakh
4. Suyansh Sharma - 20 Lakh
5. David Weise - 1 Crore
6. Kulwant Khejroliya - 20 Lakh
7. Liton Das - 50 Lakh
8. Mandeep Singh - 50 Lakh
9. Shakib Al Hasan - 1.5 Crore
LSG - Lucknow Super Gaints
1. Nicholas Pooran - 16 Crore2. Jaydev Unadkat - 50 Lakh
3. Romario Shepherd - 50 Lakh
4. Daniel Sams - 75 Lakh
5. Amit Mishra - 50 Lakh
6. Prerak Mankad - 20 Lakh
7. Swapnil Singh - 20 Lakh
8. Naveen Ul Haq - 50 Lakh
9. Yudhvir Charak - 20 Lakh
MI - Mumbai Indians
1. Cameron Green - 17.50 Crore2. Jhye Richardson - 1.5 Crore
3. Piyush Chawla - 50 Lakh
4. Duan Jansen - 20 Lakh
5. Vishnu Vinod - 20 Lakh
6. Shams Mulani - 20 Lakh
7. Nehal Wandhera - 20 Lakh
8. Raghav Goyal - 20 Lakh
PBKS - Punjab Kings
1. Sikandar Raza - 50 Lakh2. Harpreet Bhatia - 40 Lakh
3. Vidwath Kaverappa - 20 Lah
4. Mohit Rathee - 20 Lakh
5. Shivam Singh - 20 Lakh
RR - Rajasthan Royals
1. Jason Holder 5.75 Crore2. Donovan ferreria 50 Lakh
3. Kunal Rathore 20 Lakh
4. Adam Zampa 1.5 Crore
5. KM Asif 30 Lakh
6. M Ashwin 20 Lakh
7. Akash Vashisht 20 Lakh
8. Abul PA 20 Lakh
9. Joe Root 1 Crore
RCB - Royal Challengers Bangalore
1. Reece Topley 1.90 Crore2. Himanshu Sharma 20 Lakh
3. Will Jacks 3.2 Crore
4. Manoj Bhandage 20 Lakh
5. Ranjan Kumar 70 Lakh
6. Avinash Singh 60 Lakh
7. Sonu Yadav 20 Lakh
SRH - SunRisers Hyderabad
1. Harry Brook - 13.25 Crore2. Mayank Agarwal - 8.25 Crore
3. Heinrich Klassen - 5.25 Crore
4. Adil Rashid - 2 Crore
5. Mayank Markande - 50 Lakh
6. Vivrant Sharma - 2.6 Crore
7. Samarth Vyas - 20 Lakh
8. Sanvir Singh - 20 Lakh
9. Upendra Singh Yadav - 25 Lakh
10 Mayank Dagar - 1.8 crore
11. Nitish Kumar Yadav - 20 Lakh
12. Akeal Hosein - 1.5 Crore
13. Anmolpreet Singh - 20 Lakh
Purse Left after TATA IPL AUCTION 2023
Team | Auction Spent | Purse Left | Squad Size |
---|---|---|---|
CSK | 18.95 Cr | 1.50 Cr | 25 |
DC | 15 Cr | 4.45 Cr | 25 |
GT | 14.80 Cr | 4.45 Cr | 25 |
KKR | 5.40 Cr | 1.65 Cr | 22 |
LSG | 19.80 Cr | 3.55 Cr | 25 |
MI | 20.50 Cr | 5 L | 24 |
PBKS | 20 Cr | 12.20 Cr | 22 |
RR | 9.85 CR | 3.35 Cr | 25 |
RCB | 7 Cr | 1.75 CR | 25 |
SRH | 35.70 Cr | 6.55 Cr | 25 |
Top Buys at TATA IPL AUCTION 2023
Player | Winning BID | Team |
---|---|---|
Sam Curran | 18.50 Cr | PBKS |
Cameron Green | 17.50 Cr | MI |
Ben Strokes | 16.25 Cr | CSK |
Nicholas Pooran | 16 Cr | LSG |
Harry Brook | 13.25 Cr | SRH |
Mayank Agarwal | 8.25 Cr | SRH |
Shivam Mavi | 6 Cr | GT |
Jason Holder | 5.75 Cr | RR |
Mukesh Kumar | 5.50 Cr | DC |
Heinrich Klaasen | 5.25 Cr | SRH |
Money is shown in INR
Any wrong information provided please mail to us at support@bmreducation.com or at the comment section below.
Know More at iplt20.com
Comments
Post a Comment