SQL Assignment01 - Creating tables

Hello Guys, As we all know that SQL is "must" known for getting into DWH area, So considering this what I am trying to do here is sharing some basic SQL assignments to complete. Start with me if wanna to test your SQL knowledge :-)

First of all, we will create some tables ( Script may need to change as per DB you are using ) - 

	-- Creating table and Inserting Data
	-- Table Deposit
	create table deposit (
	actno varchar(5),
	cname varchar(18), bname varchar(18), amount decimal(8,2),
	adate date);
	-- Table BRANCH
	create table branch(bname varchar(18),
	city varchar(18));
	-- Table CUSTOMERS
	create table customers(cname varchar(19),
	city varchar(18));
	-- Table BORROW
	create table borrow(loanno varchar(5),
	cname varchar(18),
	bname varchar(18),
	amount decimal(8,2));
	-- Insert the data
	insert into deposit values ('100','Anil','VRCE',1000.00,'1995-03-01');
	insert into deposit values ('101','Sunil','Ajni',5000.00,'1996-01-04');
	insert into deposit values ('102','Mehul','Karolbagh',3500.00,'1995-11-17');
	insert into deposit values ('104','Madhuri','Chandni',1200.00,'1996-12-17');
	insert into deposit values ('105','Pramod','M.G. Road',3000.00,'1996-03-27');
	insert into deposit values ('106','Sandip','Andheri',2000.00,'1996-03-31');
	insert into deposit values ('107','Shivani','Virar',1000.00,'1995-09-05');
	insert into deposit values ('108','Kranti','Neharu Nagar',5000.00,'1995-07-02');
	insert into deposit values ('109','Minu','Yerwada',7000.00,'1995-08-10');
	insert into branch values ('VRCE', 'NAGPUR');
	insert into branch values ('AJNI', 'NAGPUR');
	insert into branch values ('Karolbagh', 'NAGPUR');
	insert into branch values ('Chandni', 'DELHI');
	insert into branch values ('Dharampeth', 'NAGPUR');
	insert into branch values ('M.G. Road', 'Banglore');
	insert into branch values ('Andheri', 'Mumbai');
	insert into branch values ('Virar', 'Mumbai');
	insert into branch values ('Neharu Nagar', 'Delhi');
	insert into branch values ('Yerwada', 'Pune');
	insert into customers values ('Anil', 'Calcutta');
	insert into customers values ('Sunil', 'Delhi');
	insert into customers values ('Mehul', 'Baroda');
	insert into customers values ('Mandar', 'Patna');
	insert into customers values ('Madhuri', 'Nagpur');
	insert into customers values ('Pramod', 'Nagpur');
	insert into customers values ('Sandip', 'Surat');
	insert into customers values ('Shivani', 'Mumbai');
	insert into customers values ('Kranti', 'Mumbai');
	insert into customers values ('Naren', 'Pune');
	insert into borrow values ('201','Anil','VRCE',1000.00);
	insert into borrow values ('206','Mehul','Ajni',5000.00);
	insert into borrow values ('311','Sunil','Dharampeth',3000.00);
	insert into borrow values ('321','Madhuri','Andheri',2000.00);
	insert into borrow values ('375','Pramod','Virar',8000.00);
	insert into borrow values ('481','Kranti','Nehru Nagar',3000.00);
	-- datastage4you.blogspot.in

view raw CrtTable.sql hosted with ❤ by GitHub

Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you
https://twitter.com/datastage4you
https://groups.google.com/d/forum/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098