Question

Sachin Tendulkar India's leading run scorer in cricket,ODI Batting details for a specific year 2006 are stored in a database table
​

Answer 1

Answer:

Copy of SQL Basic Aggregation 2022 Sachin Tendulkar's, India's leading run scorer in cricket, ODI(One Day International games) batting details for a specific year 2006 are stored in a database table. Schema Sample data: Only two rows are shown, real table contains more data You are expected to write an SQL query which aggregates these details on the basis of opposition . Oppositions to consider, Pakistan, Australia, and South Africa Output table format is as listed below 13310831 1. opposition 2 no_of_matches 3. total_runs 4. average_strike_rate 5. 45 6.65 Sample output row for Pakistan: Opposition No_of_matches Total_Runs Strike_rate 4s 6s 69.37 34 2 237 4 v Pakistan out for the question: Puns Strike ate s fi 2 no_of_matches 3. total_runs 2 4. average_strike_rate 5. 45 6. 65 Sample output row for Pakistan; Opposition No_of_matches Total_Runs Strike_rate 4s 6s 237 69.37 342 4 v Pakistan Expected output for the question: Opposition No_of_matches Total_Runs Strike_rate 4s 6s 69.37 34 2 237 4 50 v Pakistan 49.68 26 3 13 0 45.22 v Australia 93 4 v South Africa 1. Copy of SQL Basic Aggregation 2022 Sachin Tendulkar's, India's leading run scorer in cricket, ODI(One Day International games) batting details for a specific year 2006 are stored in a database table. Schema Sample data: Only two rows are shown, real table contains more data You are expected to write an SQL query which aggregates these details on the basis of opposition Oppositions to consider: Pakistan, Australia, and South Africa Output table format is as listed below 1. opposition 2 no_of_matches 3. total_runs 4. average_strike_rate 5. 45 6. 65 Sample output row for Pakistan: Opposition No_of_matches Total_Runs Strike_rate 4s 6s 69.37 34 2 237 4 v Pakistan for a specific year 2006 are stored in a database table, runswysur Schema You are provided 1 table: batting details. Batting details Name Type Description date STRING date of the match. runs INTEGER runs scored. minutes INTEGER duration of the match in minutes balls_faced INTEGER Number of balls played fours INTEGER number of fours sixes INTEGER number of sixes strike_rate FLOAT strike rate dismissal STRING mode of dismissal opposition STRING opposite team ground STRING match venue mordata Sample data: Only two rows are shown, real table contains more data Date Runs Minutes Balls faced Fours Sixes Strike Rate Dismis 100 06-Feb-06 113 188 10 1 Ibw 88.49 71 43 8 0 42 97.67 11-Feb-06 caugl