Perform following queries using SQL:
(i) To find the total rent earned during certain time interval (input to be given by the user) for a particular aptID.
(ii) To display all the aptIDs if the street ID and City are given.
(iii) To display the list of all the renters who have more than one apt.
(iv) To display the list of all aptIDs whose rent is equal to or more than Rs.15,000/- per month in a particular street with apt size more than 850sq feet.
(v) To display all the details of the apartment which were bought before year 2000 in a particular city and street.
(i) To find the total rent earned during certain time interval (input to be given by the user) for a particular aptID.
(ii) To display all the aptIDs if the street ID and City are given.
(iii) To display the list of all the renters who have more than one apt.
(iv) To display the list of all aptIDs whose rent is equal to or more than Rs.15,000/- per month in a particular street with apt size more than 850sq feet.
(v) To display all the details of the apartment which were bought before year 2000 in a particular city and street.
0 comments:
Post a Comment
Let us know your responses and feedback