SQL Code for Extend the code in (Perform a LEFT OUTER JOIN between the tables Wicketkeeping and Batting. You may select any column(s). Look at the result and state how many wicketkeepers have not played as batsmen (no need to write code for this part ) To show the name of the fielders who have played 7 times as many matches as the wicketkeeper(s) in 5). 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, CREATE TABLE Fielding(Player CHAR(25),CareerSpan VARCHAR(20),Matches INT,Innings INT,Catches INT,MaxCatchesInoneInning INT,CatchesPerInning NUMERIC);3,0.846);44,INSERT INTO FieldingVALUES ('AB de villiers', '2006-2017',INSERT INTO FieldingVALUES ('DA Miller',INSERT INTO FieldingVALUES ('JP Duminy',INSERT INTO FieldingVALUES ('GC Smith',INSERT INTO FieldingVALUES ('F du Plessis', ' 2012-2017',INSERT INTO FieldingVALUES('HM Amla',INSERT INTO FieldingVALUES ('J Botha',INSERT INTO FieldingVALUES ('JA Morkel',INSERT INTO FieldingVALUES('F Behardien',INSERT INTO FieldingVALUES ('DW Steyn',INSERT INTO FieldingVALUES ('JL Ontong',INSERT INTO FieldingVALUES('RJ Peterson',INSERT INTO FieldingVALUES ('RR Rossouw',INSERT INTO FieldingVALUES ('D wiese'INSERT INTO FieldingVALUES ('HH Gibbs',78,52,3,0.620);58,58,36,'2010-2018',2,0.441);77,17,34,'2007-2018',2,0.545);33,18,33,'2005- 2011',2,0.500);36,18,36,2,0.439);41,18,41,'2009-2018',2,0.425);40,40,17,'2006-2012',2,0.340);50,17,50,'2005- 2015',2,0.351);37,13,37,'2012-2018',1,0.261);42,11,42,'2007-2016',3,0.714);14,14,10,'2008-2015',2,0.476);21,10,21,'2006-2014',3,0.600);15,15,9,'2014-2016',2,0.450);20,9,20,'2013-2016',0.347);23,23,'2005- 2010',

The problem is to be solved in SQL by joining the given two tables Fielding and Wicketkeeping where…

Answered: To show the name of the fielders who…

Engineering

Computer Science

To show the name of the fielders who have played 7 times as many matches as the wicketkeeper(s)

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

Related questions

Q: Create a SQL query that pulls OrderID and OrderDate from the Orders database, as well as…

A: Definition A JOIN clause is used to merge data from more than "2" tables based on a common column…

Q: Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1…

A: The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who…

Q: SQL: Start with the Employee table used in Lab 4. CREATE TABLE Employee ( EMPLOYEE_ID…

A: Note: As you have asked multiple questions, as per our policy we will solve the first question for…

Q: Build two SQL queries that combine film and category information. List the film’s title, film’s…

A: Creating Film table: CREATE table FILM ( filmID NUMBER(3) NOT NULL, filmTitle VARCHAR2(50)…

Q: Working with the Orders table, the OrderDate and ShipDate are not in the correct MYSQL format, the…

A: SQL queries approach: 1- The first query required the DATE_FORMAT function.2- With the help of…

Q: B3. Consider the following Student table and write the appropriate relational algebra query for each…

A: I have Provided this answer with full description in step-2.

Q: Write a complete PL/SQL Cursor to retrieve the following information -Fetch row number, Employee id,…

A: Before executing the PLSQL statement first execute the command SET SERVEROUTPUT ON;. Otherwise the…

Q: d. Write an SQL query to display the client_no.order_no,status from client (matched rows), and…

A: Syntax for using inner join select col1, col2, col3 …. From table1 inner join table2 on…

Q: A) Write a query which shows the employee IDs that are unique to the employee table. Order the…

A: Solution A) - In the first part, we need to write a query to employee Ids and the employee should…

Q: tar(name: string, address: string, gender: char, birthdate: date) MovieExec(name: string, address:…

A: Given : SELECT movieTitleFROM StarsIn, MovieStarWHERE starName = name AND birthdate = 1950

Q: ase to phpMyAdmin, you should be able to view it’s four tables. 1) From the countrylanguage table,…

A: Import the “world.sql” database to phpMyAdmin, you should be able to view it’s four tables. 1) From…

Q: Construct a SQL query, using REGEXP_REPLACE, which will return all rows from project table which…

A: Question- SELECT id,REGEXP_REPLACE(title,'[0-9]','Z')AS title,start_date,end_date,budget FROM…

Q: Write SQL code for To Extend the code in ( Perform a LEFT OUTER JOIN between the tables…

A: SQL (Structured Query Language) It is a domain-precise language utilized in programming and…

Q: Write SQL Queries for following set of tables: EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary,…

A: As per our guidelines, only 3 subparts will be answered. So, please repost the remaining questions…

Q: Answer the following questions based on the information in the PATIENT table below. Write SQL…

A: The SQL query is given below with an output screenshot before and after executing the query

Q: Write a PL/SQL function that accepts employee ID as input and returns employee first name , last…

A: Below is the function that returns the upper case last, first names and email of an employee when…

Q: *Query in SQL required* Write a query to display student's Id and First Name whose from Coimbatore…

A: As per the given question we have to develop a SQL query to display student's Id and First Name…

Q: 1. Write a query to create a table employee with Emp No (4), Ename, Department, and Salary and…

A: create table tableName(columnName data type, ……) alter table tableName modify columnName data type…

Q: Write an SQL Query that lists the TeamID, bowler name, and telephone number for all bowlers. The…

A: The full query is given in next step

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

A: Given:

Q: Write a PL/SQL Function that accepts 4 integers, 2 representing the homeTeamID and visitorTeamID,…

A: Required: Write a PL/SQL Function that accepts 4 integers, 2 representing the homeTeamID and…

Q: First of all whole question is given I just need out of given queries ASAP!! Write the SQL…

A: create table User (User_id integer PRIMARY KEY, Name varchar(100), City varchar(100), Order_date…

Q: Perform a LEFT OUTER JOIN between the tables Wicketkeeping and Batting. You may select any…

A: SELECT * FROM Batting b LEFT OUTER JOIN WicketKeeping w ON b.Player = w.Player;

Q: Please give a detailed answer and code examples for all the questions. What are the types of SQL…

A: What is a SQL join A SQL Join is a special form of generating a meaningful data by combining…

Q: Write a query to display the author ID, first and last name for all authors that have never written…

A: We indeed to provide SQL query to display the author ID, first and last name for all authors that…

Q: Write a query to display the customer code, balance, and total purchases for each customer. Total…

A: SQL query: The Select statement is used for retrieving data from a database. The SQL code for…

Q: Answer the following questions based on the information in the PATIENT table below. Write SQL…

Q: How to create a query in SQL developer (oracle) to: Display Department_id, Job_id, the Average…

Q: Write an SQL query that will show all data from the Customers table andOrder By State.

A: SQL query: Query to select all the data from the “Customers” table order by “State” SELECT * FROM…

Q: Write down the SQL to show the average salary for each department together with its department name…

A: CODE: SELECT department_name, AVG(salary), COUNT(commission_pct) FROM departments JOIN employees…

Q: Write an SQL query that will select OrderID and OrderDate from theOrders table and OrderDetailID…

A: To combine rows from more than “2” tables based on a related column between them, a JOIN clause is…

Q: sql In the orders table, group by ship_via, employee_id, ship_country fields, where the ship_via…

A: Given table name: orders Field names to display: count of the number of items as total and the…

Q: Write and run an SQL query to list all students and courses they are registered for. Include, in…

A: Given: To Write and run an SQL query to list all students and courses they are registered for.…

Q: Write an SQL query to print the first three characters of FIRST_NAME from Worker table. Write an SQL…

A: We are going to write query for both 1- To print the first three characters of FIRST_NAME from…

Q: From the weather.sql file posted in classwork, rewrite the following query to use joins instead of…

A: select f.cid, f.lid from forecast f join conditions c join locations lwheref.cid=c.cid…

Q: Create a query that SELECT all of the EMPLOYEES from the EMPLOYEE TABLE that are Mangers. Include…

A: SQL self join is used to join or compare a table to itself. SQL self joins are used to compare…

Q: Answer the following questions based on the information in the PATIENT table below. Write SQL…

A: CREATE TABLE PATIENT(PID INT PRIMARY KEY, PNAME VARCHAR(10),AGE INT,ADATE DATE,GENDER VARCHAR(10));…

Q: Consider the following SQL query that seeks to find a list of titles of all coursestaught in Spring…

A: Whenever we want to retrieve data from more than 2-3 tables we use joins.There are multiple joins…

Q: *Develop a SQL Query Display all the resorts names whose star-rating ranges between 4 and 5. Sort…

A: Given: Display all the resorts name whose star rating ranges between 4 and 5. Sort the results set…

Q: Write an SQL query using the NOT operator that will show all employeeinformation from the Employee…

A: SQL query: SELECT * FROM Employee WHERE NOT Employee_Number = 7344;

Q: Assume you have these tables.. Q) Write in SQL queries to populate the above tables by inserting…

A: Tuple, in SQL is a basically a single row in the relational database table. This row consists of…

Q: Write a SQL query to display the patron ID, first and last name, and patron type for all patrons…

A: WHERE clause – It is used to limit the number of rows. ORDER BY Clause – This clause is used to sort…

Q: Using this tables.. Write in SQL queries to populate the above tables by inserting minimum 4 tuples…

A: A single row in database is called tuple. To insert multiple row in a table, use INSERT statement…

Q: I have the following problem for which I wrote teh code, but I am missing to round the last column…

A: Solution: Following is the query that retrieves assignment number, employee number, project number,…

Q: tis an SQL query for printing all details of the worker table which ordered by FIRST_NAME ascending

A: To arrange any result in ascending or descending order, we need to use ORDER BY Clause. By default…

Q: What results will the SQL queries below return? If there are errors in the queries, indicate what…

A: Query 1: Select * From Where Department.id = 1 Query 1 throws error because no table name is given,…

Q: Write SQL commands for following customer table: CustomerID Cust_Name Age Address Order_amount 101…

A: 1. Write a query to create a customer table containing above columns, whereas customer id as primary…

Q: Write the SQL code that will create the tables structures for the tables named Books, and Users.…

A: HI THERE I AM ADDING REQUIRED CODE BELOWPLEASE GO THROUGH IT THANK YOU

Q: create a query for cursor.. cursor cur1 as SELECT e.first_name, e.last_name, e.salary,…

A: SQL: "SELECT e.first_name, e.last_name, e.salary, e.job_id, j.min_salary, j.max_salary FROM…

Q: SQL: Create a SQL query that uses an uncorrelated subquery and no joins to display the descriptions…

A: Code: select p_descript from product where v_code in (select v_areacode from vendor where v_areacode…

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

SQL Code for

Extend the code in (Perform a LEFT OUTER JOIN between the tables Wicketkeeping and Batting. You may select any column(s). Look at the result and state how many wicketkeepers have not played as batsmen (no need to write code for this part ) To show the name of the fielders who have played 7 times as many matches as the wicketkeeper(s) in 5).

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,

CREATE TABLE Fielding(
Player CHAR(25),
CareerSpan VARCHAR(20),
Matches INT,
Innings INT,
Catches INT,
MaxCatchesInoneInning INT,
CatchesPerInning NUMERIC
);
3,
0.846);
44,
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', ' 2012-2017',
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
VALUES ('HH Gibbs',
78,
52,
3,
0.620);
58,
58,
36,
'2010-2018',
2,
0.441);
77,
17,
34,
'2007-2018',
2,
0.545);
33,
18,
33,
'2005- 2011',
2,
0.500);
36,
18,
36,
2,
0.439);
41,
18,
41,
'2009-2018',
2,
0.425);
40,
40,
17,
'2006-2012',
2,
0.340);
50,
17,
50,
'2005- 2015',
2,
0.351);
37,
13,
37,
'2012-2018',
1,
0.261);
42,
11,
42,
'2007-2016',
3,
0.714);
14,
14,
10,
'2008-2015',
2,
0.476);
21,
10,
21,
'2006-2014',
3,
0.600);
15,
15,
9,
'2014-2016',
2,
0.450);
20,
9,
20,
'2013-2016',
0.347);
23,
23,
'2005- 2010',

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

Introduction

SQL Command

Description

Output

Step by step

Solved in 4 steps with 4 images

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

Please modify the code below for "Current Date" ********************************************************************** from pandas_datareader import data as pdrimport yfinance as yfin # Work around until# pandas_datareader is fixed.import datetimeimport pandas as pdimport matplotlib.pyplot as pltimport numpy as np# Show all columns.pd.set_option('display.max_columns', None)pd.set_option('display.width', 1000)def getStock(stk, numDays):print(stk)# Only gets up until day before during# trading hoursdt = datetime.date.today()# For some reason, must add 1 day to get current stock prices# during trade hours. (Prices are about 15 min behind actual prices.)dtNow = dt + datetime.timedelta(days=1)dtNowStr = dtNow.strftime("%Y-%m-%d")dtPast = dt + datetime.timedelta(days=-numDays)dtPastStr = dtPast.strftime("%Y-%m-%d")yfin.pdr_override()df = pdr.get_data_yahoo(stk, start=dtPastStr, end=dtNowStr)return df################################################################### CONFIGURATION…
MySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...
Insert any 5 rows of athletes including your details into the Athletics table you created in the previous Question. The table created previously CREATE TABLE Athletics ( AthleteID int NOT NULL First_name varchar(255) NOT NULL, Last_name varchar(255) NOT NULL, DOB DATE NOT NULL, SportsCode INT, Date_Last_event DATE, PRIMARY KEY (ID) ); varchar(255) use for define string column, int stand for integer field etc.
USE supermarkett; CREATE TABLE product(product_id INT NOT NULL,product_name VARCHAR(45) NOT NULL,price FLOAT NOT NULL,prod_discount INT NOT NULL,product_type VARCHAR(45) NOT NULL,PRIMARY KEY (product_id)); CREATE TABLE stock (stock_id INT NOT NULL,product_id INT NOT NULL,quantity INT NOT NULL,product_status BOOLEAN NOT NULL,PRIMARY KEY (stock_id),FOREIGN KEY (product_id) REFERENCES product(product_id));CREATE TABLE employee (emp_id INT NOT NULL,emp_name VARCHAR(45) NOT NULL,emp_number INT NOT NULL,address VARCHAR(45) NOT NULL,PRIMARY KEY (emp_id));CREATE TABLE supplier (sup_id INT NOT NULL,sup_name VARCHAR(45) NOT NULL,sup_number INT NOT NULL,address VARCHAR(45) NOT NULL,PRIMARY KEY (sup_id));CREATE TABLE login (login_id INT NOT NULL,password VARCHAR(45) NOT NULL,PRIMARY KEY (login_id)); ALTER TABLE stockADD FOREIGN KEY (product_id) REFERENCES product(product_id); ------------------------------------------------------------------------------- make 2 different -stored procedure- query…
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
V5. min jee wants to combine the sales data from each of the art fairs. switch to the combined sales worksheet and then update the worksheet as follows. in cell A5 enter a formula without using a function that references cell a5 in the Madison worksheet. copy the formula from cell a5 to the range a6:a8 without copying the formatting. in cell b5, enter a formula using the sum function, 3d references, grouped worksheets that totals the values from cell b:5 in the chicago: madison worksheets.
CREATE TABLE MOVIE( mov_id int NOT NULL, mov_title varchar(255) NOT NULL, mov_releaseDate date, gen_id int NOT NULL, PRIMARY KEY (mov_id), FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id) ); CREATE TABLE GENRE( gen_id int NOT NULL, PRIMARY KEY (gen_id), gen_name varchar(255) NOT NULL ); Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.please use MySQL Workbench with screenshots of it for the explanation.
CREATE TABLE MOVIE( mov_id int NOT NULL, mov_title varchar(255) NOT NULL, mov_releaseDate date, gen_id int NOT NULL, PRIMARY KEY (mov_id), FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id) ); CREATE TABLE GENRE( gen_id int NOT NULL, PRIMARY KEY (gen_id), gen_name varchar(255) NOT NULL );Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.
2.7 LAB - Alter Movie table The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.
5.17 LAB - Select horses with logical operators The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
Scenario 3: Create a dictionary that will use Month name as key and number of days as values. Display only all the months that have 31 days.
1. Use the get() method to print the value of the "name" key and the value of the "age" key of the stuInfo dictionary.Use the variable given below:stuInfo = {'name': 'John Smith', "gpa": 3.456, "age": 20} 2. Use the dict() function to make a copy of the NY dictionary to NewYorkState dictionary. 3. Change the "name" value from "John Smith" to "James Bond" of the stuInfo dictionary.Use the variable given below:stuInfo = {'name': 'John Smith', "gpa": 3.456, "age": 20} need help with Python. Please help ASAP. Please please please.