1.Which players have lost more matches than the average number of losses? No duplicates should be listed. Order by player number. Insert your screen shot here.
2.How many players from each town served on the committee in any capacity? Display the town as ‘Town’ and the number served as ‘Committee Service’. Insert your screenshot here.
3.How many members come from each town? Display the town as ‘Town’ and the number of members as ‘Number’. Insert your screenshot here.
4.Who has served on the committee more than once? Display the player number as ‘Number’, concatenate the player initial and name as ‘Name’, town as ‘Town’, and number served as ‘Terms’. Insert your screenshot here.
Below I will include the tennis database
* *******************************************************************
CREATE and OPEN the TENNIS Base
******************************************************************* */
Create database tennis;
USE tennis;
#--Create table players and fill it--------------------------
Create table players
(
playerno int not null primary key,
name varchar(15) not null,
initials varchar(3),
birth_date date,
gender char(1),
joined int not null,
street varchar(15) not null,
houseno varchar(4),
zip char(6),
town varchar(10) not null,
phoneno char(10),
leagueno char(4)
);
Insert into players values
(2,'Everett','R','1988-01-09','M',2000,'Stoney Road','43','3575NH','Stratford','070-237893','2411'),
(6,'Paramenter','R','1984-06-25','M',2002,'Haseltine Lane','80','1234KK','Stratford','070-476547','8467'),
(7,'Wise','GWS','1983-05-11','M',2006,'Edgecombe Way','39','9758VB','Stratford','070-347689',Null),
(8,'Newcastle','B','1982-07-08','F',2005,'Station Road','4','6584RO','Inglewood','070-458458','2983'),
(27,'Collins','DD','1990-05-10','F',2008,'Long Drive','804','8457DK','Eltham','079-234857','2513'),
(28,'Collins','C','1983-06-22','F',2008,'Old Main 28','10','1294QK','Midhurst','071-659599',Null),
(39,'Bishop','D','1986-10-29','M',2005,'Eaton Square','78','9629CD','Stratford','070-393435',Null),
(44,'Baker','E','1983-09-01','M',2010,'Lewis Street','23','4444LJ','Inglewood','070-368753','1124'),
(57,'Brown','M','1981-08-17','M',2007,'Edgecombe Way','16','4377CB','Stratford','070-473458','6409'),
(83,'Hope','PK','1976-11-11','M',2009,'Magdalene Road','16A','1812UP','Stratford','070-353548','1608'),
(94,'Miller','P','1993-05-14','M',2013,'High Street','33A','5746OP','Douglas','070-867564',Null),
(100,'Parmenter','P','1983-02-28','M',2012,'Haseltine Lane','80','1234KK','Stratford','070-494593','6524'),
(104,'Moorman','D','1990-05-10','F',2014,'Stout Street','65','9437AO','Eltham','079-987571','7060'),
(112,'Bailey','IP','1983-10-01','F',2014,'Vixen Road','8','6392LK','Plymouth','010-548745','1319');
#--Create the table committee_members and fill it--------------------
Create table committee_members
(
playerno int not null,
begin_date date not null,
end_date date,
position varchar(20),
primary key(playerno, begin_date)
);
Insert into committee_members values
(2,'2010-01-01','2012-12-31','Chairman'),
(2,'2014-01-01',Null,'General Member'),
(6,'2010-01-01','2010-12-31','Secretary'),
(6,'2011-01-01','2012-12-31','General Member'),
(6,'2012-01-01','2013-12-31','Treasurer'),
(6,'2013-01-01',Null,'Chairman'),
(8,'2010-01-01','2010-12-31','Treasurer'),
(8,'2011-01-01','2011-12-31','Secretary'),
(8,'2013-01-01','2013-12-31','General Member'),
(8,'2014-01-01',Null,'General Member'),
(27,'2010-01-01','2010-12-31','General Member'),
(27,'2011-01-01','2011-12-31','Treasurer'),
(27,'2013-01-01','2013-12-31','Treasurer'),
(57,'2012-01-01','2012-12-31','Secretary'),
(94,'2014-01-01',Null,'Treasurer'),
(112,'2012-01-01','2012-12-31','General Member'),
(112,'2014-01-01',Null,'Secretary');
#--Create the table matches and Fill it-------------------
Create table matches
(
matchno int not null Primary Key,
teamno int not null references teams(teamno),
playerno int not null references players(playerno),
won int,
lost int
);
Insert into matches values
(1,1,6,3,1),
(2,1,6,2,3),
(3,1,6,3,0),
(4,1,44,3,2),
(5,1,83,0,3),
(6,1,2,1,3),
(7,1,57,3,0),
(8,1,8,0,3),
(9,2,27,3,2),
(10,2,104,3,2),
(11,2,112,2,3),
(12,2,112,1,3),
(13,2,8,0,3);
#--Create Table Penalties and Fill it-------------------------------------
create table Penalties
(
paymentno int not null Primary Key,
playerno int not null references players(playerno),
payment_Date date not null,
amount decimal(10,2) not null
);
Insert into Penalties values
(1,6,'2010-12-08',100.00),
(2,44,'2011-05-05',75.00),
(3,27,'2013-09-10',100.00),
(4,104,'2014-07-08',50.00),
(5,44,'2010-12-08',25.00),
(6,8,'2010-12-08' ,25.00),
(7,44,'2012-12-30',30.00),
(8,27,'2014-08-12',75.00);
#--Create Table Teams and Fill it----------------------------------------------
Create table teams
(
teamno int Primary Key Not Null,
playerno int Not Null references players(playerno),
division varchar(6)
);
Insert into teams values
(1,6,'first'),
(2,27,'second');
/* ********************************************************************************************
End of loading the database
******************************************************************************************** */
In: Computer Science
Does a mother who is found guilty of using drugs during the conception of a child deserve the opportunity to earn back her parental rights?
In: Psychology
How did the colonists mobilize for war? Discuss specific challenges they faced and any unintended consequences of their solutions.
In: Psychology
There are 5000 CFM of outdoor air with a temp of 40F 35Fwb heated and humidified under steady-flow conditions to a final temp of 70F and 40%RH a)find the mass of water vapor added to each pound mass of dry air b) if the water is supplied at 50F how much heat in Btu/min.
In: Mechanical Engineering
1) How does capital investment affect the marginal physical product of labor? Does more college education have the same kind of effect? Which is a better investment? Please explain your answers in detail.
(2) While explaining your answer in detail, if you wish, you can also include an example. According to the rule for optimal input usage, a firm should hire a person as long as her marginal revenue product is greater than her marginal cost to the company. It is well known that many companies have management training programs in which new trainees are paid relatively high starting salaries and are not expected to make substantial contributions to the company until after the program is over (programs may run between 6 to 18 months). In offering such training programs, is a company violating the optimality rule? Explain.
In: Operations Management
Growth Company's current share price is $ 20.10 and it is expected to pay a $ 0.95 dividend per share next year. After that, the firm's dividends are expected to grow at a rate of 4.4 % per year. a. What is an estimate of Growth Company's cost of equity? b. Growth Company also has preferred stock outstanding that pays a $ 2.25 per share fixed dividend. If this stock is currently priced at $ 28.15, what is Growth Company's cost of preferred stock? c. Growth Company has existing debt issued three years ago with a coupon rate of 6.1 %. The firm just issued new debt at par with a coupon rate of 6.4 %. What is Growth Company's cost of debt? d. Growth Company has 5.3 million common shares outstanding and 1.4 million preferred shares outstanding, and its equity has a total book value of $ 49.9 million. Its liabilities have a market value of $ 19.5 million. If Growth Company's common and preferred shares are priced as in parts (a) and (b), what is the market value of Growth Company's assets? e. Growth Company faces a 38 % tax rate. Given the information in parts (a) through (d), and your answers to those problems, what is Growth Company's WACC? Note: Assume that the firm will always be able to utilize its full interest tax shield.
In: Finance
GSU president is trying to analyze crime rates so they can shift their patrols from decreasing-rate areas to areas where rates are increasing. The city and county have been geographically segmented into areas containing 5,100 residences. The police recognize that not all crimes and offenses are reported: people do not want to become involved, consider the offenses too small to report, are too embarrassed to make a police report, or do not take the time, among other reasons. Every month, because of this, the police are contacting by phone a random sample of 1,020 of the 5,100 residences for data on crime. (Respondents are namelessness.) Here are the data collected for the past 12 months for one area:
MONTH CRIME SAMPLE CRIME
INCIDENCE SIZE RATE
January 9 1,020 0
February 11 1,020 0
March 9 1,020 0
April 9 1,020 0
May 9 1,020 0
June 11 1,020 0
July 10 1,020 0
August 12 1,020 0
September 10 1,020 0
October 13 1,020 0
November 11 1,020 0
December 10 1,020 0
a. Determine the P−, Sp, UCL and LCL for a p-chart of 95 percent confidence (at Z = 1.96). (Round your answers to 5 decimal places.)
P−
Sp
UCL
LCL
b. If the next three months show crime incidences in this area as
January = 10 (out of 1,020 sampled)
February = 12 (out of 1,020 sampled)
March = 11 (out of 1,020 sampled)
What comments can you make regarding the crime rate?
The process is in control.
The process is out of control
In: Operations Management
A 13.35-year maturity zero-coupon bond selling at a yield to maturity of 8% (effective annual yield) has convexity of 164.2 and modified duration of 12.36 years. A 40-year maturity 6% coupon bond making annual coupon payments also selling at a yield to maturity of 8% has nearly identical modified duration—-12.30 years—-but considerably higher convexity of 272.9.
a. Suppose the yield to maturity on both bonds
increases to 9%. What will be the actual percentage capital loss on
each bond? What percentage capital loss would be predicted by the
duration-with-convexity rule? (Do not round intermediate
calculations. Round your answers to 2 decimal
places.)
Zero-Coupon Bond | Coupon Bond | |||
Actual loss | % | % | ||
Predicted loss | % | % | ||
b. Suppose the yield to maturity on both bonds
decreases to 7%. What will be the actual percentage capital gain on
each bond? What percentage capital gain would be predicted by the
duration-with-convexity rule? (Do not round intermediate
calculations. Round your answers to 2 decimal
places.)
Zero-Coupon Bond | Coupon Bond | |||
Actual gain | % | % | ||
Predicted gain | % | % | ||
In: Finance
1. Solve the equations 256? ≡ 442(??? 60), 3? + 4 ≡ 6(??? 13).
5. Prove that ?2 + ? + 1 is an irreducible polynomial of degree 2.
In: Advanced Math
What was the significance of the Battle of Stone's River?
In: Psychology
When an opinion poll calls landline telephone numbers at random,
approximately 30% of the numbers are working residential phone
numbers. The remainder are either non-residential, non-working, or
computer/fax numbers. You watch the random dialing machine make 20
calls. (Round your answers to four decimal places.)
(a) What is the probability that exactly 4 calls reach working
residential numbers?
(b) What is the probability that at most 4 calls reach working
residential numbers?
(c) What is the probability that at least 4 calls reach working
residential numbers?
(d) What is the probability that fewer than 4 calls reach working
residential numbers?
(e) What is the probability that more than 4 calls reach working
residential numbers?
In: Math
In: Finance
In: Electrical Engineering
In: Computer Science
Q5: Which type of RAM is used exclusively in laptops?
Q6: Which firmware security standard can be used to store disk encryption keys?
Q7: Which RAID level is Disk Mirroring?
Q8: Which type of printer uses toner?
Q9: Which technique do 3D printers use to create objects?
Q10: Which of the following item DOES NOT store data?
In: Computer Science