Need help ASAP witht heses SQL commands if someoen could help me i\'ll gretaly a

Question

Need help ASAP witht heses SQL commands if someoen could help me i'll gretaly appreciate it thanks!

Solmaris Condominium Group 1. 2. 3. For every condo, list the location number, unit number, condo fee, owner number, owner's first name, and owner's last name. For every completed or open service request for janitorial work, list the condo ID, description, and status. For every service request for janitorial work, list the condo ID, location number, unit number, estimated hours, spent hours, owner number, and owner's last name. List the first and last names of all owners who have a three-bedroom condo. Use the IN operator in your query. 4.

Explanation / Answer

Please give the thumbs up, if it is helpful for you!!. Let me know if you have any doubts.

#1)

SELECT LocationNum, UnitNUm, COndoUnit.OwnerNum. FirstName, LastNmae
FROM CondoUnit, OWner
WHERE CondoUnit.OwnerNum = Owner.OwnerNum;

# 2)

SELECT CONDO_ID,DESCRIPTION,STATUS
FROM SERVICE_REQUEST
WHERE STATUS IN ('Completed', 'Open') AND
CATEGORY_NUM IN ( SELECT CATEGORY_NUM FROM SERVICE_CATEGORY WHERE CATEGORY_DESCRIPTION = 'janitorial' ) ;

# 3)

SELECTS.CONDO_ID, S.EST_HOURS, S.SPENT_HOURS, C.LOCATION_NUM, C.UNIT_NUM, C.OWNER_NUMBER, O.LAST_NAME
FROM CONDO_UNIT as C, OWNERS as O, SERVICE_REQUEST as S
WHERE S.CONDO_ID = C.CONDO_ID AND
C.OWNER_NUM = O.OWNER_NUM
S.CATEGORY_NUM IN ( SELECT CATEGORY_NUM FROM SERVICE_CATEGORY WHERE CATEGORY_DESCRIPTION = 'janitorial' )

#4)

SELECT FIRST_NAME, LAST_NAME
FROM OWNER.CONDO_UNIT
WHERE OWNER.OWNER_NUM =CONDO_UNIT.OWNER_NUM AND CONDO_UNIT.BDRMS IN (3);

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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