IN MY SQL:

- Display each Author’s ID, first and last names and the total number of pages for all of the Books they have written.

- Display each Book genre as well as the number of Books written in that genre with the column header “Number Of Books”

- Display the Author’s first and last name, as well as their ID, and the Book title and number of pages for all of the books they have written that have more than the average number of pages for all of the books that have been written, listed by author’s first and last name along with the book title, and the book’s number of pages.

- Display the Author’s or Authors’ ID, first and last name of the Author who has the most Books in the Coastal Publishing database.

LINK TO WHAT THE SETUP AND INSERTS LOOK LIKE:

https://docs.google.com/document/d/1Qb30rS-g03pUBBFGBRwq-f9L8CsHY0Dz_HKpt_lt9uM/edit?usp=sharing

Please read the text below and answer the following questions..

Santa Barbara is a small (imaginary) nation in Central America. Universidad Nacional de 
Santa Barbara (the National University of Santa Barbara) is the most prestigious 
university in the region. The main campus is in the capital, Ciudad de Santa Barbara, and 
enrolls more than 25,000 students in bachelor's, master's, and doctoral programs covering 
a wide variety of academic disciplines. Three regional campuses enroll approximately 
10,000 additional students.
A meeting is scheduled between a group of senior administrators of Universidad 
Nacional de Santa Barbara and sales representatives from Z-Term Solutions, a major 
supplier of instructional technology consulting services including installation hardware 
and software for distance education and video conference.
The American representatives of Z-Term Solutions are on the third week of a seven 
country sales trip. The firm's specialty is videoconference solutions for business and 
education. The firm provides consulting, sales, installation, and service. Z- 
Term Solutions carries the best brands and the most up to date equipment. The firm is 
eager to expand its sales in Central and South America. In an effort to do so, Z-Term 
Solutions hired a sales team leader from the Central America region.   
The two representatives of Universidad Nacional de Santa Barbara are high-level 
administrators with responsibility for strategic and financial planning. The Minister of 
Education routinely endorses any agreements approved by these two administrators. Both 
of these two administrators come from well-established families and have important 
connections in the Prime Minister's office. Both are on career paths that will likely lead to 
high positions in one of the ministries as their careers progress. 


1. If you were the sales team leader from the Central America region of Z-Term Solutions, what motivation strategy would you use to enhance the two American sales representatives global negotiation skills?  

Develop your own three original discussion questions in relation to the case scenario above. 


1.
2.
3.

How is the supreme court case Int'l Refugee Assistance Project v Trump. different from the US Court of Appeals case of the same name?

Use excel and show both the numbers and the formulas so I can learn how to do it

If I want to invest $1200 a year for 20 years and then stop investing for 10 years, to pay for my slacker child to get a doctorate, how much will I need to invest a year in my final 10 years of work to get my $2,000,000 to make me really happy at 12% interest?

Peter lives for three periods. He is currently considering three alternative education-work options. He can start working immediately and earn $100,000 in period 1, $110,000 in period 2, and $90,000 in period 3. Alternatively, he can spend $50,000 to attend college in period 1 and then earn $180,000 in period 2 and 3. Finally, he can receive a doctorate degree in period 2 after completing his college education in period 1. This last option will cost him nothing in period 2 as his graduate school expenses on tuition and books will be covered by a research assistantship. After receiving his doctorate degree, he will become a professor in a business school and earn $400,000 in period 3.

Peter must make all college related expenses at the beginning of each period and he is paid at the end of every period.

a) Suppose that the market interest rate is given by 20 percent. What education path maximizes Peterís net present value of life time earnings?

b) What will be the optimal decision if the market interest rate is given by 0 percent?

The student will write a 2-3 page review of a scholarly article on the global marketing mix or identifying alternatives strategies for entering foreign markets and tactical skills needed to craft PR and advocacy campaigns in different regions of the world. Reviews should include a synopsis and your opinion of the article. The submission is to be double spaced using a 12 point font and will be graded based on depth and clarity. You need to include both the name and author of the article. This assignment is due on 04/30/2020 in class.

Using the CAPM, calculate the 2016 expected return on Facebook’s shares.

Assumptions:

Risk-free rate, Rf = 2.5%

E(Rm) = 7.5%

Use the SP500 index to proxy for the market portfolio.

Hints to calculate beta:

- Use daily stock returns during 2016 (start date 01-Jan-2016, end date 31-Dec-2016).

- Download stock prices for Facebook and the SP500 with ticker name FB and ^GSPC, respectively, from www.finance.yahoo.com.

- Use adjusted prices to calculate returns.

Answer true/false for the following:

1. The power stroke is generated during the contraction-relaxation phase.

2. Reformation of cross bridges occurs during the excitation-contraction phase.

Three identical point charges of charge q = 5 uC are placed at the vertices (corners) of an equilateral triangle. If the side of triangle is a = 3.3m, what is the magnitude, in N/C, of the electric field at the point P in one of the sides of the triangle midway between two of the charges?