The following requirement is to update TST1_Q5 table in your DB account. Write single update statement to modify student GPA as following, both part a and part b should be met by a single update statement. student table contains stdno, stdgpa, stdclass

offering table contains offerno, offyear

enrollment table contains stdno, offerno, enrgrade

a) set student GPA to the average grade the student received for the classes taken in 2017(offyear).

b) if student did not take classes in 2017 (offyear), leave GPA unchanged.

Bond x is noncallable and has 20 years to maturity, a 7% annual coupon, and a $1,000 par value. your required return on bond x is 10%; if you buy it, you plan to hold it for 5 years. you (and the market) have expectations that in 5 years, the yield to maturity on a 15-year bond with similar risk will be 9.5%. how much should you be willing to pay for bond x today? (hint: you will need to know how much the bond will be worth at the end of 5 years.) do not round intermediate calculations. round your answer to the nearest cent.

Advanced enterprises reports year-end information from 2018 as follows: sales (160,250 units) $968,000 cost of goods sold 641,000 gross margin 327,000 operating expenses 263,000 operating income $64,000 advanced is developing the 2019 budget. in 2019 the company would like to increase selling prices by 14.5%, and as a result expects a decrease in sales volume of 9%. all other operating expenses are expected to remain constant. assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. should advanced increase the selling price in 2019?

Richard is one of the leading college basketball players in the state of florida. he also maintains a good academic record. looking at his talent and potential, furman university offers to bear the expenses for his college education.