For the relations answer the following queries in SQL
Street (name, location, city)
House (number, street_name)
Lives (name, house_number)
(i) Obtain the names of persons who live in the street named ‘Mahatma Gandhi'.
(ii) Obtain the house numbers street wise.
(iii) Obtain the numbers of houses which are not occupied.
(i) Select lives.name from Street, House, Lives where Street.name = House.street_name and House. Number = Lives. House_number and street_name =
‘Mahatma Gandhi';
(ii) Select number from House
order by street_name;
(iii) Select number from house
minus
Select house_number from lives;