a) Write down the SQL Statement for the below Queries

b) Supply sample tale output

c) the database Used is the University Schema downloaded at lecture

1. Write a query to display the name for those Students who gets more Tot_Cred than the Student whose ID is 55739.

2. Write a query to display the name salary, department name, instructor id for those instructors who works in the same department as the instructor works whose id is 83821.

3. Write a query to display the name salary, department id for those instructor who earn such amount of salary which is the smallest salary of any of the departments

4. Write a query to display the instructor id, instructor name for all instructor who earn more than the average salary.

5. Write a query to display the department name, name for all instructor in the Comp. Comp. Sci.

6. Write a query to display all the information of the instructors whose salary is within the range 60000 and 90000

7. Write a query to display all the information of the instructor whose salary is within the range of smallest salary and 60000

8. Write a query to display all the information for those instructor whose id is any id who earn the second highest salary

9. Write a query to display the instructor number and name for all instructors who work in a department with any instructor whose name contains a T.

10. Write a query to display the instructor id, name, and salary for all instructor who earn more than the average salary and who work in a department with any employee with a i in their name

11. Display the instructor name, id, for all instructor whose department building is Taylor.

12. Write a query to display the instructor name and department for all instructors for any existence of those employees whose salary is more than 70000.

13. Write a query to display the department name and the total salary for those departments which contains at least one instructor

Values Rule at Patagonia

Patagonia is a California-based company that makes clothing and gear for outdoor sports like hiking and

climbing. It has been called “The Coolest Company on the Planet” and it has a consistent track record of

being voted one of the best companies to work for. Patagonia employees are among some of the most

passionate and long serving in the industry. In fact, with an annual turnover rate of only 4 percent, so few

people leave the company that job seekers are hard pressed to find any opportunities. However, when

the company does have a position to fill, it goes about selecting candidates very carefully.

Patagonia places its commitment to protect and preserve the environment and its resources over

anything else. This mind set is what drives the company and the people who work there. As Casey

Sheahan, CEO and president of Patagonia, observes, “It is critical that our employees, whether they are

new hires or long standing employees, are totally in line with our philosophy and values.” It is not enough

for an applicant to simply enjoy outdoor activities. Patagonia looks for employees who are fanatical about

protecting the environment and who are passionate about their hobbies and interests. The company looks

carefully at the values, attitudes, and behaviours of potential employees in an effort to bring in new talent

that will help the organization as a whole and be truly representative of the Patagonia brand.

Patagonia uses a hiring process that is a mixture of both traditional and nontraditional approaches.

Résumés are reviewed and sorted, and candidates are screened in-person and over the phone.

However, in order to find an employee who will be the best fit for the organization, candidates also

participate in extensive group interviews. The purpose of this strategy is to learn as much about the

candidate’s background as possible. As Lu Setnika, human resources director at the company, explains,

group interviews provide an opportunity for Patagonia employees to test and assess whether or not a

candidate would be comfortable working within the organization’s value-driven and collaborative culture.

By having a number of informal conversations together, both the company and the candidates take time

to get to know each other. This helps Patagonia maintain a base of employees who are highly engaged

and who identify with the organization on an emotional level.

Patagonia’s mission statement is to build the best product, cause no unnecessary harm, and use

business to inspire and implement solutions to environmental crises, and this mission drives the

company’s corporate strategy. The apparel and gear made by Patagonia employees are secondary to the

company’s commitment to resolving environmental issues. Jill Dumain, Patagonia’s director of

environmental analysis, explains that the return on investments with environmental protocols is actually a

much more efficient way of doing business from a cost standpoint. The company harnesses the strengths

and potential of customers who are aware of the plight of the environment and willing to take action. In

this way, Patagonia promotes and encourages a lifestyle that honours nature, wildlife, and biodiversity.

As illustrated in its Common Threads Initiative Video, Patagonia’s message is very clear: The planet’s

resources are being depleted at a level that cannot be sustained. Urgent change is needed to allow

nature time to heal. With these facts in mind, the company urges customers to think carefully and buy

only what they “deeply need” and not “vaguely want.” Company founder, YvonChinourd, explains that

“We are the first company to ask consumers to take a formal pledge and be partners in the effort to

reduce consumption and keep products out of the landfill or incinerator.” Patagonia’s Common Threads

Pledge states that Patagonia agrees “to build useful things that will last, to repair what breaks and recycle

what comes to the end of its useful life.” Customers who take the pledge agree “to buy only what [they]

need and will last, repair what breaks, reuse (sell or share) what [they] longer need and recycle

everything else.”

Following its belief that recycling is one key factor in sustaining the environment, Patagonia partnered

with eBay to create its Common Threads Initiative Store. This new approach enables and encourages

customers who have taken the Common Threads Pledge to take an active role in the partnership.

Patagonia says it will not receive any of the profits associated with the Common Threads Initiative

Storefront.

Patagonia recognizes and supports employees who engage in projects as environmental activists. In

1993, the company started its Patagonia Employee Internship Program. It provided staff with an

opportunity to leave their jobs for up to four weeks to work for an environmental group they identified with.

Patagonia agreed to provide full pay and benefits to employees during their absence from the company.

More than 850 employees have taken part in the program. Interns have helped to protect sea turtles in

Kenya, pika in Colorado, and sage grouse in Nevada. Employees who participate in the program further

strengthen Patagonia’s mission. Their stories and experiences help to inspire other employees and in the

process work to enrich and strengthen Patagonia’s collaborative culture. In some cases, employees leave

the company to concentrate all of their efforts on preserving the environment. Patagonia applauds

employees who leave the company to devote all of their time in support of environmental initiatives. The

company views these kinds of employee resignations as organizational successes.

On April 20, 2010, BP’s Deepwater Horizon oil rig exploded in the Gulf of Mexico. That began what is now

known as the biggest oil spill in history, with at least 185 million gallons of crude pouring into the Gulf.

Patagonia responded to the disaster by sending seven teams of employees to seven communities in the

Gulf. For one week, employees went door to door and asked residents along the coast in southern

Louisiana towns how the oil spill had impacted them in terms of health, culture, and finances. Information

from the survey helped to create a web-based Oil Spill Crisis Map that the government and wildlife

agencies could use to document the impact of the disaster.

Patagonia’s organizational culture places it in a leading role as a company devoted to the preservation

and protection of the environment. Its unique approach of using and uniting its employees and customers

in pursuit of its mission offers hope and guidance to others who seek to live as citizens of the earth.

Discussion Questions

1. Explain the difference between “values,” “attitudes,” and “job satisfaction.” How does each pertain to Patagonia and its employees? Give examples.

2. What is the difference between terminal and instrumental values? Which of the terminal andinstrumental values apply to Patagonia’s employees?

3. Patagonia experiences a high level of organizational commitment from their employees, which isdemonstrated by their low annual turnover rate of 4 percent. Describe the three types of organizational commitment and explain how each pertains to Patagonia.

4. Patagonia gives employees paid time off to pursue their environmental passions. From a businessperspective, do you think this is a good idea or not? How do you think it impacts Patagonia as anorganization? Explain.

5. Patagonia has incorporated group interviews into their hiring process as they feel this is a good way “to assess whether or not a candidate would be comfortable working within the organization’s value driven and collaborative culture.” Do you agree with this assessment? Explain.

A individual has a utility function u(c) = √ c, where c is the individual’s consumption. (The individual consumes his entire wealth.) The individual’s wealth is $40,000 per year. However, there is a 2% chance that he will be involved in a catastrophic accident that will cost him $30,000.

PLEASE SHOW WORK

a. What is the individual’s utility from consumption if there is no accident? What is his utility if there is an accident? What is his expected utility?

b. What is the actuarially fair insurance premium if the individual purchases an insurance contract that pays out $30,000 in the event of an accident? What is his utility if there is no accident, and he purchases the actuarially fair insurance? What is his utility in the event of an accident if he purchases the actuarially fair insurance?

c. What is the most that he would be willing to pay for insurance given his utility function?

An Individual consumes commodity bundles including two goods: P and Q. The satisfaction/value/utility obtained for the individual is provided by the following equation – 3*(units of P)^2 + 2*(units of Q). Now answer the following questions

a. Compute the utility got the following bundles – (12, 5), (2,7) and (8,5)
b. Considering a utility level of 75 units; identify one consumption bundle that provided that level of utility
c. Now draw an indifference curve for the individual with an utility of 75
d. Provided the unit cost of P is 12$ and unit cost of Q is 3$ - determine the cost of the consumption bundle you identified from part (b)
e. For 75 units of utility, given the units costs, find the optimal consumption bundle (find the bundle on the indifference curve that has the lowest cost)

When someone says that they're "buying American dollars" (USD), what type of asset are they probably buying? They're probably buying:

(a) Short term debt denominated in USD, for example lending to a US bank as a USD deposit.

(b) Long term debt denominated in USD, for example lending to a US company by buying their USD bonds.

(c) Shares denominated in USD, for example buying shares in Coca-Cola which is listed on the NYSE.

(d) Real estate denominated in USD, for example buying an apartment in Chicago.

(e) Commodities with USD, for example buying gold, wheat, or coal.

inbound taxation questions

True / False Questions

1. Service revenue is sourced based on the location in which such services are rendered.
2. Income tax treaties can generally only result in an increase in the amount of U.S. tax due.
3. The purpose of the foreign tax credit is to reduce international double taxation.
4. Under present law, a trust is considered a US person only if a US court has primary supervision over the trust’s administration and US persons have the authority to control all substantial decisions of the trust.
5. Fixed or determinable, annual or periodical income from foreign sources is subject to Internal Revenue Code section’s 1441 and 1442.

The global average carbon footprint is 4 metric tons per person. Why do you think the US has a much higher average carbon footprint per person?

The average world temperature has increased by 2 degrees fahrenheit over the last 140 years. Experts predict the average world temperature could increase by another 2-10 degrees fahrenheit by the year 2100. What are 3 possible consequences that could result from this warming?

The US has one of the highest carbon footprints per capita in the world. What are 3 ways the US could reduce carbon emissions?

The current pandemic crisis caused a depreciation of Canadian dollar compared to the US dollar. The exchange rate increased from US$1 = C$1.30 in February to US$1 = C$1.40 in May.

1. a) If you want to explain this increase in the exchange rate with the changes in the Canadian interest rate. What would be your interpretations? Did the Central Bank in Canada cut the interest or increase it? And how that can affect the rise in the exchange rate?

2. b) What is the implication of your answer in (a) for the Canadian bond’s price? Write down the equation for the price of bond and explain how your result in (a) can affect the price of bond?

President Calvin Coolidge once exclaimed that "the business of the United States IS business." When considering life in the US today, one cannot deny the observation. Even education and prison has become a business industry. The business-oriented nature of the US did not happen overnight and goes back to the very origins of the US. Considering this, (a) explain the origins of the original two colonies, Jamestown and Plymouth. Explain how they fulfilled mercantilist objectives on the part of the English Crown. Also, (b) how did African slavery originate from business purposes? Finally, (c) how was the Civil War a result of economic factors regarding industrialization and slavery?