Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.
SQL Assignment
Name Omitted
20th November 2021
1. Find the propId, locDesc, and state for properties with a propType equal to “T”
(i.e., traditional)
SELECT propId, locDesc, state FROM property WHERE propType='T';
Result set
2. Find the propId and startDt for properties which the customer named Ava Kashun
has a rental
SELECT p.propId, startDt FROM property p INNER JOIN rental r ON p.propId=r.propId
INNER JOIN customer c ON c.custNr= r.custNr WHERE c.name='Ava Kashun';
Result set
3. Find the property Id and locDesc of properties in TX (state) which have a start date
after “2019-11-03” for the customer named “Perry Scope”.
SELECT p.propId, locDesc FROM property p INNER JOIN rental r ON p.propId=r.propId
INNER JOIN cu...