Write and run SQL statements to complete the following tasks

1. Show the details of the employees who are located in area code 901 and their manager employee number is 108.
2. Show the details of the employees who are also mangers.
3. Show the details of the customers whose balance is greater than 220 but less than 500.
4. Show the details of the customers whose balance is highest.
5. Show customer 10014’s name and the product’s descriptions which he/she purchased and the number of units of each.
6. List the names of customers and the number of invoices each customer has generated.
7. Show the codes and names of the customers who have not generated any invoice.
8. Add a new attribute (column) engaged varchar(3) to the customer table and update the engaged attribute for the customers who have not generated any invoice to ‘No’.

The number of female customers arriving to a coffee shop follow a Poisson process with a mean rate of 3 per hour. The number of male customers arriving to the same coffee shop also follow a Poisson process with a mean rate of 6 per hour and their arrival is independent of the arrivals of female customers.

a) What is the probability that the next customer will arrive within 5 minutes?

b) What is the probability that exactly thee customers will arrive in the next 5 minutes?

c) What is the probability of exactly two male and exactly one female customer will arrive in the next 5 minutes?

d). Parts b) and c) ask for the probability of exactly three arrivals in the next 5 minutes. Are they identical? Explain why?

e) What is the probability of exactly five customers will arrive between 6 and 7 hours from now?

Two shops A and B attract two types of customers: price-sensitive customers, who shop at the lower-priced shop, and time-sensitive customers, who shop at whichever shop is on their side of the street. A customer of either type purchases on average 10 goods. Assume there are 800 price-sensitive customers and 500 time-sensitive customers buying goods on any given day. The wholesale price the shop pay per good is $3. For simplicity, assume that they can charge $3.50, $4.00, or $4.50 per good.

a. Complete the matrix depicting each station’s profit given the possible strategy profiles.

b. Are there any dominant strategies or dominated strategies? Explain briefly.

c. Are there any pure-strategy Nash equilibrium? If so, give the strategy profiles and corresponding outcomes.

Company MNO generates between 11000 and 15000 million dollars revenue per year. Suppose that the company's revenue stays within this range. Use an interest rate of 9.75% per year compounded continuously. Fill in the blanks in the paragraph below, rounding your answers to the nearest tenth.

The present value of MNO's revenue over a five year period is between _______________ and ______________ million dollars.

Over a twenty-five year period, the present value falls between ____________ and _____________ million dollars

7aresh company has these accounts on 31st december 2019:

• Cash of $9,380
• Wage Expense of $300
• Accounts Payable of $8,900
• Cost of Goods Sold of $5,900
• Unearned Revenue of $1,170
• Gain on Sale of Equipment of $120
• Inventory of $6,230
• Sales Revenue of $7,510
• Interest Expense of $1,280
• Common Stock (no par value) of $4,610
• Rent Revenue of $1,230
• Retained Earnings of $2,030
• Depreciation Expense of $365
• Prepaid Insurance of $2,100

as of december 31st 2019, provide 7aresh's journal entry

The Herald marketing department is seeking to increase home-delivery sales through an aggressive direct-marketing campaign that includes mailings, discount coupons, and telephone solicitations. Feedback from these efforts indicates that getting their newspapers delivered early in the morning is a very important factor for both prospective and existing subscribers. After several brainstorming sessions, a team consisting of members from the marketing and circulation departments decided that guaranteeing newspaper delivery by a specific time could be an important selling point in retaining and getting new subscribers. The team concluded that the Herald should offer a guarantee that customers will receive their newspaper by a certain time or else that day’s issue is free. To assist the team in setting a guaranteed delivery time, Al Leslie, the research director, determined that the circulation department had data that showed the percentage of newspapers yet undelivered every quarter hour from 6AM to 8AM. Jan Shapiro remembered that customers were asked on their subscription forms at what time they would be looking for their copy of the newspaper to be delivered. These data were subsequently combined and are available below. Your job is to review the internal data and propose a reasonable time (to the nearest quarter hour) to guarantee delivery. To help explore the effects of your choice, calculate the following probability: If a sample of 50 customers is selected on a given day, what is the probability, given your selected delivery time, that a. Fewer than 3 customers will receive a free newspaper? b. 2, 3, or 4 customers will receive a free newspaper? c. More than 5 customers will receive a few newspaper? Use the binomial distribution function in excel to perform required calculations.

Pete’s Pizza and Pasta is a newly formed chain of pizza and pasta restaurants. The company’s strategy is to grow the brand through franchising and increase market share and profitability for both individual restaurants as well as the entire chain.

Pete, the founder of the chain has given you the following balanced scorecard, which he is confident would help the company achieve his stated strategy. Pete expects to generate income largely through initial franchising fees as well as collecting a percentage of the franchisees’ revenues.

Required:
For each of the four balanced scorecard perspectives, please perform the following:

i)     Provide two additional strategic objectives and key performance indicators.

ii)     Discuss, how and why recommended objectives and indicators from Part (i) above will help Pete execute his strategy.