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

******************************************************************************************** */

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?

How did the colonists mobilize for war? Discuss specific challenges they faced and any unintended consequences of their solutions.

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.

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.

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.

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

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.)

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.)

1. Solve the equations 256? ≡ 442(??? 60), 3? + 4 ≡ 6(??? 13).

5. Prove that ?2 + ? + 1 is an irreducible polynomial of degree 2.

What was the significance of the Battle of Stone's River?

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?

Q5:      Which type of RAM is used exclusively in laptops?

• SODIMM
• DDR3
• DDR
• DDR4

Q6:      Which firmware security standard can be used to store disk encryption keys?

• SLA
• TPM
• UEFI
• USB

Q7:      Which RAID level is Disk Mirroring?

• 3
• 1
• 0
• 5

Q8:      Which type of printer uses toner?

• Impact
• Inkjet
• Thermal
• Laser

Q9:      Which technique do 3D printers use to create objects?

• Fusing
• Heating
• Layering
• Carving

Q10:    Which of the following item DOES NOT store data?

• Random Access Memory
• CD-R
• LCD Screen
• USB Drive