Write the SQL Code forSelect the names of wicketkeeper along with the number of sixes that they have hit (while batting) ?table is in the pic CREATE TABLE wicketkeeping (Player CHAR(25),CarrerSpan VARCHAR(20),Matches INT,Innings INT,Dismissals INT,Catches INT,Stumpings INT,MaxiumDismissalsInOneInning CHAR(15),DismissalsPerInnings NUMERICINSERT INTO wicketkeepingJALUES('Q de Kock',INSERT INTO wicketkeepingVALUES('AB de villiers', '2006-2017',INSERT INTO wicketKeepingVALUES('MV Boucher',INSERT INTO wicketKeepingVALUES('M Mosehle',INSERT INTO wicketKeepingJALUES('H Klaasen',INSERT INTO wicketkeepingJALUES ('HG Kuhn',INSERT INTO WwicketKeepingVALUES('MN van Wyk',INSERT INTO wicketKeepingJALUES ('DJ Vilas',30,9,'4 (3ct 1st)', 1.218);'2012-2018',32,32,39,7,'4 (4ct Øst)', 1.076);78,26,28,21,19,18,1,'3 (3ct Ost)', 0.760);'2005- 2010',25,25,6,2,'3 (2ct 1st)',1.142);'2017-2017',7,7,8,0,'2 (2ct Ost)', 1.333);'2018-2018',4,3,4,4,4,0,'3 (3ct Ost)', 0.800);'2009-2017',7,5,A,1,'1 (1ct Øst)', 0.800);' 2007-2015',8,5,4,3,0,0,'0',0.000);'2012-2012',1,1,0, BallingREATE TABLE Batting (Player CHAR(25),CarrerSpan VARCHAR(20),Matches INT,Innings INT,Playing INT,Runs INT,Highestscore CHAR(10),AverageScore NUMERIC,BallsFaced INT,strikeRate NUMERIC,Hundreds INT,Fifties INT,Zeros INT,Fours INT,Sixs INTNSERT INTO BattingALUES ('JP Duminy', '2007-2018',NSERT INTO BattingALUES ('AB de villiers', '2006-2017',NSERT INTO BattingFALUES ('HM Amla', '2009-2018', 41, 41, 5,NSERT INTO BattingALUES ('F du Plessis', '2012-2017',NSERT INTO BattingALUES ('DA Miller', '2010-2018',NSERT INTO BattingALUES('GC Smith', '2005-2011', 33, 33, 2,NSERT INTO BattingALUES('Q de Kock','2012-2018', 32, 32, 4,NSERT INTO BattingALUES ('JH Kallis', '2005- 2012',NSERT INTO BattingALUES('JA Morkel',NSERT INTO BattingALUES('F Behardien',NSERT INTO Batting77, 71, 22,1825,'96*',37.24,1468,124.31, 0,11,б,130,65);78, 75, 11,1672,'79*',26.12,1237,135.16, 0,10,5,140,60);1158,'97*',32.16,883,131.14, 0,7,2,133,23);36, 36, 6,1129,119,37.63,849,132.97, 1,7,0,102,35);58, 51, 15,1043,'101*', 28.97,745,140.00, 1,1,0,71,46);982,'89*',31.67,770,127.53, 0,5,1,123,26);821,59,29.32,637,128.88, 0,2,3,97,24);25, 23, 4,666,73,35.05,558,119.35, 0,5,0,56,20);'2005 - 2015',50, 38, 11,572,43,21.18,402,142.28, 0,0,1,29,39);'2012-2018',37, 29, 13,515,'64*',32.18,402,128.10, 0,1,1,37,16);

SQL Joins are used to combine rows from two or more tables, having some columns common between them.…

Answered: Write the SQL Code for Select the…

Write the SQL Code for Select the names of wicketkeeper along with the number of sixes that they have hit (while batting) ?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Write SQL command that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each…

A: The sql query is solved in step2

Q: How is the underscore character different from the % character in SQL?

A: Difference between underscore character and % character in SQL:

Q: What did each card cost? Show the card number, player last name, team name, price, price with 5%…

Q: Write the SQL code that will compute the total number of hours worked and total amount billed by all…

A: To compute the total number of hours worked and total amount billed by all workers, we need to have…

Q: Write the T-SQL scripts for the following tasks: - Write a query to list all the Employee's details…

A: let us see the answer:- Introduction:- We are going to use a select query to list all the Employees…

Q: in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: Write the following insert statements. 3. Insert a guest into the table, Guest, using the following…

A: Answer: 3)Performing insert statement: INSERT INTO Guest(guestNo, lastName, firstName, phoneNo,…

Q: t the title of all books in the same category as books previously purchased by customer 1007. Don’t…

A: Lets see the solution.

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: I was wondering if you could do this in PL/SQL format. declare begin end; etc

A: DECLARE The user must declare any variable before using it in a batch or method. The memory…

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: Write the T-SQL scripts for the following tasks: Write a query to select the count of employees…

A: SELECT COUNT(*)FROM employees_tableWHERE department = "Marketing";

Q: Write all the sql code (including create, insert and select)

A: #use the below query to create users tablecreate table users(account int primary key,name…

Q: The following SQL clause(s) are not permitted to be used in a subquery in the WHERE or HAVING…

A: Multicolumn subqueries cannot use the <, >, <=, >= comparison operators.

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: a) Group all…

A: Process To display the all the data we use select * from tablename and condition what we want to get…

Q: Write an SQL query that will show all order numbers in the Orders tablebetween 1002 and 1008

A: SQL query: Query to show all order numbers in the “Orders” table between 1002 and 1008 SELECT * FROM…

Q: For each band that currently has a female member: Return the name of the band and each artist's…

A: The question has asked us to join three tables, namely, p_artist, p_band, and p_member, based upon…

Q: Write and SQL query using the MAX operator to show all data from the Order Items table in which the…

A: The Structured Query Language (SQL) query to display all the data from the Order items table in…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

Write the SQL Code for

Select the names of wicketkeeper along with the number of sixes that they have hit (while batting) ?

table is in the pic

CREATE TABLE wicketkeeping (
Player CHAR(25),
CarrerSpan VARCHAR(20),
Matches INT,
Innings INT,
Dismissals INT,
Catches INT,
Stumpings INT,
MaxiumDismissalsInOneInning CHAR(15),
DismissalsPerInnings NUMERIC
INSERT INTO wicketkeeping
JALUES('Q de Kock',
INSERT INTO wicketkeeping
VALUES('AB de villiers', '2006-2017',
INSERT INTO wicketKeeping
VALUES('MV Boucher',
INSERT INTO wicketKeeping
VALUES('M Mosehle',
INSERT INTO wicketKeeping
JALUES('H Klaasen',
INSERT INTO wicketkeeping
JALUES ('HG Kuhn',
INSERT INTO WwicketKeeping
VALUES('MN van Wyk',
INSERT INTO wicketKeeping
JALUES ('DJ Vilas',
30,
9,
'4 (3ct 1st)', 1.218);
'2012-2018',
32,
32,
39,
7,
'4 (4ct Øst)', 1.076);
78,
26,
28,
21,
19,
18,
1,
'3 (3ct Ost)', 0.760);
'2005- 2010',
25,
25,
6,
2,
'3 (2ct 1st)',
1.142);
'2017-2017',
7,
7,
8,
0,
'2 (2ct Ost)', 1.333);
'2018-2018',
4,
3,
4,
4,
4,
0,
'3 (3ct Ost)', 0.800);
'2009-2017',
7,
5,
A,
1,
'1 (1ct Øst)', 0.800);
' 2007-2015',
8,
5,
4,
3,
0,
0,
'0',
0.000);
'2012-2012',
1,
1,
0,

Balling
REATE TABLE Batting (
Player CHAR(25),
CarrerSpan VARCHAR(20),
Matches INT,
Innings INT,
Playing INT,
Runs INT,
Highestscore CHAR(10),
AverageScore NUMERIC,
BallsFaced INT,
strikeRate NUMERIC,
Hundreds INT,
Fifties INT,
Zeros INT,
Fours INT,
Sixs INT
NSERT INTO Batting
ALUES ('JP Duminy', '2007-2018',
NSERT INTO Batting
ALUES ('AB de villiers', '2006-2017',
NSERT INTO Batting
FALUES ('HM Amla', '2009-2018', 41, 41, 5,
NSERT INTO Batting
ALUES ('F du Plessis', '2012-2017',
NSERT INTO Batting
ALUES ('DA Miller', '2010-2018',
NSERT INTO Batting
ALUES('GC Smith', '2005-2011', 33, 33, 2,
NSERT INTO Batting
ALUES('Q de Kock','2012-2018', 32, 32, 4,
NSERT INTO Batting
ALUES ('JH Kallis', '2005- 2012',
NSERT INTO Batting
ALUES('JA Morkel',
NSERT INTO Batting
ALUES('F Behardien',
NSERT INTO Batting
77, 71, 22,
1825,
'96*',
37.24,
1468,
124.31, 0,
11,
б,
130,
65);
78, 75, 11,
1672,
'79*',
26.12,
1237,
135.16, 0,
10,
5,
140,
60);
1158,
'97*',
32.16,
883,
131.14, 0,
7,
2,
133,
23);
36, 36, 6,
1129,
119,
37.63,
849,
132.97, 1,
7,
0,
102,
35);
58, 51, 15,
1043,
'101*', 28.97,
745,
140.00, 1,
1,
0,
71,
46);
982,
'89*',
31.67,
770,
127.53, 0,
5,
1,
123,
26);
821,
59,
29.32,
637,
128.88, 0,
2,
3,
97,
24);
25, 23, 4,
666,
73,
35.05,
558,
119.35, 0,
5,
0,
56,
20);
'2005 - 2015',
50, 38, 11,
572,
43,
21.18,
402,
142.28, 0,
0,
1,
29,
39);
'2012-2018',
37, 29, 13,
515,
'64*',
32.18,
402,
128.10, 0,
1,
1,
37,
16);

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: SQL JOIN

VIEW

Step 2: SQL Query

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions

Write all the sql code (including create, insert and select)
CREATE TABLE Employee( firstName char(30) , lastName char(30) , hireDate date ,empNo int , empInitial char(30) , years int ); Write the SQL syntax to create an insert statement for the employee table you created above.
How do you compose a subquery in SQL where you are searching for the most common value in one column for a specific value from another column (i.e. looking for the down where most penalties occur --> down is a column and PlayType is a column with penalties as a value). The columns are in the same table.
Write an SQL query using the NOT operator that will show all employeeinformation from the Employee table with the exception of EmployeeNumber 7344.
What are some common uses for the STRING_AGG function in SQL?
How do I do this question in SQL command? Use the Oracle database employees table and CASE expression to decode the departmentid. Display the department id, last name, salary, and a column called “New Salary” whose value is based on the following conditions: If the department id is 10 then 1.25 * salary If the department id is 90 then 1.5 * salaryIf the department id is 130 then 1.75 * salary Otherwise, display the old salary.
Please help: Using the following sql file, how would you find List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number and department name should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
Using DML SQL, write the appropriate SQL query for each of the following:a) Insert A new customer with the following information:(Name: Ali, SSN: 1111, Address: Riyadh, Phone: 05555)b) Delete all the loans for customer with SSN: 2222c) Select all customer who got loans more than 250000 SAR, print the customers SSN, named) Print all the Accounts in Bank: ALBILAD and in branch no: 5
Write the T-SQL scripts for the following tasks: Write a query to list the first name and last name of the employee with the highest salary in the financedepartment
Write an appropriate SQL query to display all the STUDENT_SURNAMES and STUDENT_NAMES, as well as the MODULE_NAMES that the student is registered for. Sort results according to student surname in ascending order.
Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).