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

In java Write a static method named consecutiveDigits that accepts an integer n as a parameter and that returns the highest number of consecutive digits in a row from n that have the same value. For example, the number 3777785 has four consecutive occurrences of the number 7 in a row, so the call consecutiveDigits(3777785) should return 4.

For many numbers the answer will be 1 because they don't have any adjacent digits that match. Below are sample calls on the method. You are not allowed to use a String to solve this problem. You may assume that the value passed to the method is greater than or equal to 0.

consecutiveDigits(99) will return 2

consecutiveDigits(1) will return 1

consecutiveDigits(11335577) will return 2

consecutiveDigits(12345) will return 1

consecutiveDigits(89995) will return 3

1. Ras nucleotide exchange is stimulated by ___.
2. A mutation in RTK receptor that allows the receptor to bind the ligand and pair with a wild-type receptor but blocks signal transduction is classified as a ________ ________ mutation, whereas a mutation that activates RTK pairing signal transduction even in the absence of ligand is classified as a ______________ _______ mutation.
3. PTEN is a phosphatase that removes a phosphate group from ____, thereby preventing its activation of Akt kinase.

Select ALL possible answers: Explain where aqueous humor is produced and the function of this fluid in the eye.

A game show has a host and three contestants. Suppose the three contestants are Meg, Tyler and Ashley. The host and each contestant each have a bag with 3 marbles; one red, one white and one blue. The host will choose a marble from her bag, then Meg will choose a marble from her bag. If Meg’s marble is the same color as the host, then Meg has won and the game is over. If Meg loses, then Tyler will choose a marble from his bag. If Tyler chooses a marble the same color as the host or Meg, then he wins. If Tyler does not win then Ashley will choose a marble from her bag. Well, from here you can probably guess what it takes for Ashley to either win or lose. (Each choice will be random.)

A: Does every contestant have a chance to win? Explain.

B: Is it possible for none of the contestants to win? Explain.

C: Why are these first two questions important to ask and answer?

D: Is one contestant more likely to win than the other two? Explain.

E: Calculate the probability of a win for each contestant.

Consider a game of chance consisting of a single trial with exactly two outcomes, which from a players perspective we will call "win" and "lose." To play the game, a player must wager an amount, which we will denote by a. If the player loses the game, a player loses their wager. If the player wins the game, then they keep their wager and they win $1.00. Denote the probability by p, where 0 < p < 1. Let the random variable X denote the amount won by the player.

A) Find the sample space of the random variable X.

B) Find the pmf of the distribution of the random variable X.

C) Compute the expression for E(X), the expected value of X.

D) A game is said to be fair if the expected amount won is 0. For what value of a, the amount wagered, would the game be described as a fair game?

E) For what vaules of a is E(X) >0?

F) For what values of a is E(X) <0?

G) Suppose a person is only willing to play if their expected amount won is non negative. For what values of a would this person be willing to play, and what values of a would this person not be willing to play?

Historically, the number of cars arriving per hour at Lundberg’s Car

Wash is observed to be the following:

a. Set up a probability distribution table (including the lower end of

the probability range) for the car arrivals.

b. Simulate 25 hours of car arrivals. What is the average number of

arrivals per hour?

c. Repeat part b multiple times (by pressing F9). Over what range

does the average number of arrivals vary?

d. Now simulate 500 hours of car arrivals. What is the average

number of arrivals per hour?

e. Repeat part d multiple times (by pressing F9) Over what range

does the average number of arrivals vary?

f. Do your answers for part c and e differ? Why or why not?

A retail corporation wants to know how often a customer returns items in a year. The company’s data analytics team analyzed customers’ shopping behavior and came up with three categories of customers. Customers in category 1 do not return items often. Customers in category 2 return some items, and customers in category 3 heavily return items. Suppose that the data analytics team modeled the number of returns in each category of customers according to a Poisson process with rates λ1 = 1 per year, λ2 = 4 per year, and λ3 = 10 per year for categories 1, 2, and 3, respectively. Category 1 customers constitute 30% of the customer base of this retail corporation, whereas Category 2 and 3 customers constitute 60% and 10% of the customer base, respectively.

(a) What is probability that the company gets 10 returned items from a customer during 2019 and 2020 (this time period includes both years 2019 and 2020)? Do NOT calculate a number. Just write an expression for this probability.

(b) Compute the mean and variance of the number of returned items for a customer during 2019 and 2020.

(c) Now consider a category 2 customer. Compute the mean and variance of the number of returned items for this customer (=a category 2 customer) during 2019 and 2020.

(d) Given that a customer returns 10 items in his or her first 2 years, what is the probability this is a category 2 customer? Do NOT calculate a number. Just write an expression for this probability.

Use Python to write the following code.

Program Specifications:

You are to design the following menu:

G] Get a number

S] Display current sum

A] Display current average

H] Display the current highest number

L] Display the current lowest number

D] Display all numbers entered

Q] Quit

If the user enters G, S, A, H, L, or D before selecting G the program needs to advise the user to go and enter a number first.

Rules for the Programmer (you)

1. Source code must use a dynamic list to store all numbers
2. Source code must have a function for each of the menu options above (I guess even for quit too]
3. Source code must have reasonable comments
4. Source code must not allow the user to do bad things (you can assume they will enter a number if they press G or if you want to figure it out, yell at the user if he or she does not enter a number)