#3 , please help me the query using SQL Management Studio and run to show the ou

Question

#3 , please help me the query using SQL Management Studio and run to show the output, Thanks

U rlOse Cly Is BOWTON, BowTon, BoWtOn, and so on. 3. Solmaris is offering a monthly discount for owners who pay their condo fees on a quar- terly basis. The discount is 1.75 percent of the monthly fee. For each condo, ist the loca on number, unit number, owner number, owner's last name, condo fee, and discount. The discount should be rounded to the nearest dollar. 4. Write PLSOL T SOU nrduroc t accomnlish the following tasks:

Explanation / Answer

Assuming (May change upon previous parts of question):

Table: condo

Columns: condo_id, condo_fee, location_number, unit_number, owner_number, owner_fname, owner_lname

Query: SELECT location_number, unit_number, owner_number, owner_lname, condo_fee, ROUND(condo_fee * 0.0175, 0) AS discount FROM condo;

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.