Suppose,Cricket World Cup has taken place.I want to build a database to record all the scores of every match . Design this database so that we can store data efficiently and also can easily find answer of the following statistical question.
-
a. Which batsman has the most runs?
-
b. Which bowler has the most wickets?
- c. Which country has highest score in a single iings?
- d. Which country has the lowest score in a single iingsuf04c?
- e. What is the highest score made by a batsman played at position 6?
- f. What is the average score of Bangladesh?
I need to design database and write query for above statistics.
My Idea:-
Table : Players column will be PlayerID,Country,Name
Table : Matches column will be PlayerID,run,matchID,Wicket
I am not sure if it is efficient design to run those queries,I am looking forward suggestions.