In the following exercise, you will use the Access Files located in the Files se

Question

In the following exercise, you will use the Access Files located in the Files section of your Canvas shell. For this assignment I do not want a MS Access file but rather a snapshot of the SQL commands and the result of the query after it is executed
3. From the Solmaris Condominium Group database, for every service request for electrical system, list the condo ID, location number, unit number, estimated hours, spent hours, owner number, and owner’s last name.
Locatiorn LocationNum LocationName Address City State PostalCode 1 Solmaris Ocean 100 Ocean Ave. Bowton FL 3131:3 2.1 ISolmaris Bayside 140SBayside Blvda Gland 31044

Explanation / Answer

begin

insert into #serviceRequest

select condoId,estHours,spentHours from ServiceRequest where categorynum=(SELECT

categorynum from ServiceCategory where categoryDescription='Electrical Systems')

insert into #serviceRequest1 select a.condoId,b.locationNumber,b.unitNum,b.OwnerNum,a.estHours,a.spentHours from #serviceRequest a,CondoUnit b where a.condoId=b.condoId

insert into #serviceRequest2 select a.condoId,a.locationNumber,a.unitNum,a.OwnerNum,a.estHours,a.spentHours,b.lastName

from #serviceRequest1 a, Owner b where a.OwnerNum=b.OwnerNum

select condoId,locationNumber,unitNum,estHours,spentHours,ownerNum,lastName from #serviceRequest2

end

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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