Nilesh Sanyal

Nilesh Sanyal

  • NA
  • 83
  • 36.6k

SQL Query

Aug 11 2013 12:03 PM
Consider following tables:

PLAYER(NAME,COUNTRY,AGE)

P_DATA(NAME,M_DATE,RUNS,WICKETS,CATCHES,AGAINST)

SQL Queries

1)List players who have played against all countries

2)For each country, name the player(s) who have scored maximum runs,taken maximum wickets in a match


Please provide SQL codes to solve above mentioned queries.

Answers (4)