CREATE TABLE Fielding( Player CHAR(25), CareerSpan VARCHAR(20), Matches INT, Innings INT, Catches INT, MaxCatchesInOneInning INT, CatchesPerInning NUMERIC ); 0.846); INSERT INTO Fielding VALUES('AB de villiers', '2006-2017', INSERT INTO Fielding VALUES('DA Miller', INSERT INTO Fielding VALUES('JP Duminy', INSERT INTO Fielding VALUES('GC Smith', INSERT INTO Fielding VALUES('F du Plessis', INSERT INTO Fielding VALUES('HM Amla', INSERT INTO Fielding VALUES('J Botha', INSERT INTO Fielding VALUES('JA Morkel', INSERT INTO Fielding VALUES('F Behardien', INSERT INTO Fielding VALUES('DW Steyn', INSERT INTO Fielding VALUES ('JL Ontong', INSERT INTO Fielding VALUES('RJ Peterson', INSERT INTO Fielding VALUES('RR Rossouw', INSERT INTO Fielding VALUES('D Wiese', INSERT INTO Fielding 78, 52, 44, 3, 36, 0.620); 58, 58, 3, '2010-2018', 2, 0.441); 77, 77, 34, '2007-2018', 18, 2, 0.545); '2005- 2011', 33, 33, 2, 0.500); 36, 36, 18, '2012-2017', 2, 0.439); '2009- 2018', 41, 41, 18, 2, 0.425); 40, 40, 17, '2006- 2012', 2, 0.340); 50, 50, 17, '2005- 2015', 2, 0.351); 37, 37, 13, '2012-2018', 1, 0.261); 42, 42, 11, '2007-2016', 10, 3, 0.714); 14, 14, '2008-2015', 2, 0.476); 21, 10, '2006- 2014', 21, 9, 3, 0.600); 15, 15, '2014-2016', 0.450); 20, 20, 9, '2013-2016', 3, 0.347); 23, 8, 23, '2005-2010', VALUES('HH Gibbs', 2,
CREATE TABLE Fielding( Player CHAR(25), CareerSpan VARCHAR(20), Matches INT, Innings INT, Catches INT, MaxCatchesInOneInning INT, CatchesPerInning NUMERIC ); 0.846); INSERT INTO Fielding VALUES('AB de villiers', '2006-2017', INSERT INTO Fielding VALUES('DA Miller', INSERT INTO Fielding VALUES('JP Duminy', INSERT INTO Fielding VALUES('GC Smith', INSERT INTO Fielding VALUES('F du Plessis', INSERT INTO Fielding VALUES('HM Amla', INSERT INTO Fielding VALUES('J Botha', INSERT INTO Fielding VALUES('JA Morkel', INSERT INTO Fielding VALUES('F Behardien', INSERT INTO Fielding VALUES('DW Steyn', INSERT INTO Fielding VALUES ('JL Ontong', INSERT INTO Fielding VALUES('RJ Peterson', INSERT INTO Fielding VALUES('RR Rossouw', INSERT INTO Fielding VALUES('D Wiese', INSERT INTO Fielding 78, 52, 44, 3, 36, 0.620); 58, 58, 3, '2010-2018', 2, 0.441); 77, 77, 34, '2007-2018', 18, 2, 0.545); '2005- 2011', 33, 33, 2, 0.500); 36, 36, 18, '2012-2017', 2, 0.439); '2009- 2018', 41, 41, 18, 2, 0.425); 40, 40, 17, '2006- 2012', 2, 0.340); 50, 50, 17, '2005- 2015', 2, 0.351); 37, 37, 13, '2012-2018', 1, 0.261); 42, 42, 11, '2007-2016', 10, 3, 0.714); 14, 14, '2008-2015', 2, 0.476); 21, 10, '2006- 2014', 21, 9, 3, 0.600); 15, 15, '2014-2016', 0.450); 20, 20, 9, '2013-2016', 3, 0.347); 23, 8, 23, '2005-2010', VALUES('HH Gibbs', 2,
Chapter9: Working With Text Functions And Creating Custom Formats
Section: Chapter Questions
Problem 1.7CP
Related questions
Question
SQL CODE FOR
- For the players who show up in Batting, Bowling, and Fielding tables, create a list that shows their names, runs they have scored, wickets they have taken, and catches they have taken?
table is in picture
(bowling table is same as batting and fielding )
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage