Лаба 2 / 5-8

/* 5 */

select TreatyID, Compensation/Cost as profit from Treaty

select TreatyID, Floor*Floors as FF from Flat


select Chief, ActionID+PatrolID as summa from Action

/* 6 */
select TypeHouse+' '+TypeDoor as dom_dver from Flat


/* 7 */
select * from Flat
where AddressFlat in (select distinct AddressFlat from Action)


/* Update Action set Chief='Бугагаев' where PatrolID=1* --по условию */

/*Update Flat set TypeHouse='Кирпичный' --все строки */

/*
delete from Flat where AddressFlat in (select distinct AddressFlat from Action)
delete from Action where PatrolID=1
*/

select * from Treaty

select * from [User]