The management of ABC Real Estate wants to know the details of the agent who sold property
Fantastic news! We've Found the answer you've been seeking!
Question:
The management of ABC Real Estate wants to know the details of the agent who sold property ID '25'. This can be done in two ways:
I. Sub-Query
II. Joins
Write one (1) MySQL statement for each to achieve this. Both queries should return exactly the same result, and the result should be displayed in the following format. Agent ID, Name, Age, Gender.
They agency also wants to know the details of all the properties owned by the Vendor ID '22'. Write one (1) MySQL statement to list the properties owned by Vendor ID '22'. Your query should return a table in the following format. Property ID, Property Suburb, Built Year.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: