lab3

select * from propertyforrent; --l

select * from propertyforrent where type='House'; --2

select * from client;
select clientno as "client number",
        fname as "first name",
        lname as "last name",
        telno as "telephone number"
    from client where preftype='Flat'; --3

select * from viewing;
select clientno, viewdate from viewing where propertyno = 'PG21' and comments is not null; --4

select distinct * from propertyforrent where ownerno is null; --5

select * from staff;
select staffno as "staff number",
        fname as "first name",
        lname as "last name",
        salary as "salary"
        from staff where sex='M'and salary>10000 ; --6

select * from staff;
select staffno as "staff number",
        fname as "first name",
        lname as "last name",
        dob as "birth date"
        from staff where dob>'1-JAN-1960' order by dob; --7

select * from privateowner;
select ownerno as "owner number",
        fname||lname as "name",
        address as "address"
        from privateowner where address not like '%Glasgow%'; --8

select * from branch;
select street,city,postcode
        from branch where city in ('Aberdeen','Bristol'); --9

select * from staff;
select branchno as "branch no",
        salary as "salary"
        from staff order by branchno, salary desc; --10