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.

Suppose someone wants to sell a piece of land for cash. the selling of a piece of land represents turning

3. now assume that carnival booked lady antebellum in december 2016 to perform on the june 2017 western caribbean cruise. further assume that carnival pays lady antebellum its entire performance fee of $52,000 on december 28, 2016, for the june 2017 cruise. what journal entry will carnival make on december 28, 2016, for its payment to lady antebellum?

Lavage rapide is a canadian company that owns and operates a large automatic car wash facility near montreal. the following table provides data concerning the company’s costs: fixed cost per month cost per car washed cleaning supplies $ 0.70 electricity $ 1,400 $ 0.07 maintenance $ 0.15 wages and salaries $ 4,900 $ 0.30 depreciation $ 8,300 rent $ 1,900 administrative expenses $ 1,400 $ 0.03 for example, electricity costs are $1,400 per month plus $0.07 per car washed. the company expects to wash 8,000 cars in august and to collect an average of $6.50 per car washed. the actual operating results for august appear below. lavage rapide income statement for the month ended august 31 actual cars washed 8,100 revenue $ 54,100 expenses: cleaning supplies 6,100 electricity 1,930 maintenance 1,440 wages and salaries 7,660 depreciation 8,300 rent 2,100 administrative expenses 1,540 total expense 29,070 net operating income $ 25,030 required: calculate the company's revenue and spending variances for august.