Lab-4

Q1. Write queries for creating the above tables considering the red marked fields as primary keys and green marked fields as foreign keys.

Q2. Insert these data into the tables

Q3. Write these queries

i) Select all those player names who play for CSK & KKR team and having Average more than 30 and less than 40. ii) Select team names where players’ average is more than 35.

iii) Select all the team names who has international players.