// DDL Example: Create a table
create table branch
(branch_name    char(15) not null,
branch_city    char(30),
assets    integer)


// DDL Example: Create a view
create view branch_loan as
select branch_name, loan-number
from loan


// DML Example
select * from branch;

// DML Example
select customerName from (depositor natural full outer join borrower)
where account_number is null or loan-number is null;