Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
MS-SQL Homework with script
Solmaris Condominium Group
Use SQL and the Solmaris Condominium Group database (see Figures 1-9 through 1-13 in Chapter 1) to complete the following exercises. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output or save it to a document.
- @
- 17 orders completed
- ANSWER
-
Tutor has posted answer for $11.00. See answer's preview
****** *** ** quetsion 1*/ ** * *** every condo **** the ******** number **** ****** ***** fee owner ****** *********** ***** name and *********** **** name */ SELECT ********************** ****************** ******************* CONDO_UNITCONDO_FEE *************** OWNERLAST_NAME **** CONDO_UNIT **** OUTER **** ***** ON ********************************** ***** ** ******************** ** quetsion *** ** **** the ***** *** **** ***** of *** owners who **** * ************* ***** *** the ** operator ** **** ***** 1*/ ****** *************** ************** FROM ********** **** OUTER **** OWNER ** OWNEROWNER_NUM=CONDO_UNITOWNER_NUM ***** CONDO_UNITBDRMS ** **** ** ******** *** ****** the unit ******* ** *** **** ** ****** that **** *** **** ****** ******* For ******* *** **** ***** ** **** ****** *** and **** ****** *** because *** ****** footage *** both units is **** ****** feet *** ***** **** ****** listed ****** ** *** ***** **** *** *** *** ****** **** number ****** ** *** ***** sort *** ** SELECT ****************** FROM ********** WHERE EXISTS ******* ****** **** CONDO_UNIT WHERE **************** * CONDO_UNITSQR_FT ***** BY SQR_FT); /* ******** **** ****** *** location ****** **** ****** *** condo fee *** condos ***** owners **** in Bowton *** own * *********** condo ** ****** CONDO_UNITLOCATION_NUM ****************** ******************* FROM ********** **** ***** **** ***** ** ********************************** ***** *************** * 1 *** *************************** /* ******** **** /*12 **** *** ******* ID and ***** ** *** **** ******* request whose ********* hours ** ******* than *** ****** ** estimated hours ** ** ***** *** ******* ******* ** ***** the ******** ****** ** * ** ****** ************************* *********************** FROM *************** WHERE (EST_HOURS>SPENT_HOURS) *** *************** ** ******** ** ** ****** *** ***** ID ****** footage ***** ****** ******* ** ****** ** ********* ***** *** ****** of ***** ***** *** **** ******* ******* ** which *** ******** number ** 4 ** ****** ****************** **************** CONDO_UNITOWNER_NUM ************************* ************************ ************************** **** ********** LEFT ***** **** *************** ON ****************************************** ***** SERVICE_REQUESTCATEGORY_NUM=4; ****** 2*/ /* ******** 1 ****** a *********** table **** *** ********* ***** ** ********* ***** ****** ***** LARGE_CONDO ************* *********** *** NULL ******** ******* *** **** BDRMS *********** ***** DECIMAL(20) CONDO_FEE *********** ********* ******* ** /* ******** * Insert **** the *********** ***** *** location ****** **** ****** ******** ***** ***** *** and ***** ****** *** ***** ****** ***** ****** footage ** greater **** **** ****** **** ** ****** **** *********** (LOCATION_NUMUNIT_NUMBDRMSBATHSCONDO_FEEOWNER_NUM) ****** ************************************************ FROM ********** WHERE ******* ********* * ** * ******** has ********* *** ***** *** ** **** ***** ***** ** **** ****** the ***** **** In the *********** ***** *********** ** ****** *********** *** **************************** /* * After ********** the ***** *** of each ***** ***** ** **** ********* ** ******** decides ** ******** *** ***** *** ** *** ***** ***** monthly *** ** more than $750 ** *** percent ****** *** ***** fees ** *** *********** table *********** ** UPDATE *********** *** CONDO_FEE=(99/100*CONDO_FEE) ***** (CONDO_FEE>750); /* * ****** * row **** the LARGE ***** ***** for * new ***** The ******** number ** * *** unit ****** ** *** the number ** ******** ** * *** number ** ********* ** 3 the ***** fee is $775 *** *** ***** ****** ** ***** */ INSERT **** LARGE_CONDO ************************************************** ********************************************* ** * Delete all ****** ** *** *********** table for which *** owner ****** is ***** ** ****** **** *********** ***** OWNER_NUM='AN175'; /* 7 *** condo ** ******** * and unit *** is in the ******* ot ***** ********* *** the number ** bedrooms is unknown ****** *** ******** ***** ** the *********** ***** to null */ ***** ***** *********** ALTER COLUMN BDRMS *********** ***** /* 8 Add ** *** LARGE_CONDO table * new ********* ****** ***** OCCUPIED that ** *** ********* ** ****** (This column **** ******** ******* the ***** ** ********* ********* *** *** ***** *** *** ******** ****** ** all **** ** * ** ALTER ***** *********** *** ******** ******** /*SET VALUES TO *************** ****** LARGE_CONDO *** OCCUPIED='Y'; ** * Change *** ******** ****** ** *** *********** ***** to * for **** *** ** ****** *********** *** ******************** ***** *********************** **** Change *** ********* column in the ***** CONDO ***** ** ****** nulls*/ ***** ***** *********** ALTER ****** ********* *********** *** *****
