From the database scheme write the query(all tables are empty) 1) Insert your name and your phone as a new tenant 2) Delete your phone number from the table tenant. 3) Create a new contract lease for you. 4) Delete the contract that you created. 5) List the city name, city population and country name.
From the
1) Insert your name and your phone as a new tenant
2) Delete your phone number from the table tenant.
3) Create a new contract lease for you.
4) Delete the contract that you created.
5) List the city name, city population and country name.
6) List the cities that have the letters “re” in any part of the name;
7) List the tenant name contract number, rent price, when the contract rent price is bigger equal 500 and lower equal 1000.
8) List all columns from apartments with the services offered (all columns from service).
9) List the building address, the city name and the country name for the building in Canada.
10) List the name of the user with the city name and country name, ordering by name of user.
Step by step
Solved in 7 steps with 7 images
