(Solved): CIS365 A6 - Group/Nest/Views/Transactions - 3 bonus points for early submission( insights)...

CIS365  A6

/* W6A1*/

/*Q1. (8) (Join) We're getting ready for the new season. When was the last time each condo was cleaned? Display the

Building Number, Unit, and Date Last Cleaned. Order by the unit number within the building.

(No need to check the date as 2019)

*/

GO

SELECT CL.Condo# ,

       BldgNum

                ,UnitNum

      ,MAX(DateCleaned) AS "LAST DATE CLEAN"

                FROM CLEANING CL JOIN condos C ON CL.Condo#=C.CondoNum

 GROUP BY CL.Condo#,BldgNum,UnitNum

------------------------------------------------------------------------