1. List names of all employees who are not from Department A00. 2. What is the average of all employee salaries? 3. Which employees earn more than average? 4. List names and salaries of employees earning more than $35,000. 5. Increase Ms. Haas's salary to $500,000 and then list her new monthly salary.

Exercise 18-15 sheffield appliance center is an experienced home appliance dealer. sheffield appliance center also offers a number of services for the home appliances that it sells. assume that sheffield appliance center sells ovens on a standalone basis. sheffield appliance center also sells installation services and maintenance services for ovens. however, sheffield appliance center does not offer installation or maintenance services to customers who buy ovens from other vendors. pricing for ovens is as follows. oven only $790 oven with installation service 850 oven with maintenance services 970 oven with installation and maintenance services 990 in each instance in which maintenance services are provided, the maintenance service is separately priced within the arrangement at $180. additionally, the incremental amount charged by sheffield appliance center for installation approximates the amount charged by independent third parties. ovens are sold subject to a general right of return. if a customer purchases an oven with installation and/or maintenance services, in the event sheffield appliance center does not complete the service satisfactorily, the customer is only entitled to a refund of the portion of the fee that exceeds $790. assume that a customer purchases an oven with both installation and maintenance services for $990. (b) indicate the amount of revenue that should be allocated to the oven, the installation, and to the maintenance contract.

12. to produce a textured purée, you would use a/an a. food processor. b. wide-mesh sieve. c. immersion blender d. food mill.

Ancho corp. is an automobile company whose core competency lies in manufacturing petrol- and diesel- based cars. the company realizes that more of its potential customers are switching to electric cars. the r& d department of the company acquires competencies in developing electric cars and launches its first hybrid car, which uses both gas and electricity. in this scenario, ancho is primarilya. leveraging new core competencies to improve current market position. b. redeploying existing core competencies to compete in future markets. c. unlearning existing core competencies to create and compete in markets of the future. d. building new core competencies to protect and extend current market position