DS $530$ Week $5$ Assignment

Data Management Systems

Due Date: $\frac{4}{10},$ end of day

Join $($with inner join$)$ person, personphone, phonenumbertype, and businessentity in the persons schema.

Return Business entity id$,$ First name, middle name, last name, phone number and the name of the phone number type $($home$,$ office, etc.$)$

Order by business entity id descending. Limit the result set to $20$ rows.

Join $($inner$)$ productmodel, productmodelproductiondescriptionculture, productdescription and culture

from the production schema.

Return the productmodel name, culture name, and productdescription description ordered