create database sallu
use sallu

create table customeer(
	c_id int,c_name varchar(10),
	c_age int, c_salary int,
	primary key(c_id))

select * from customeer
select * from orders
drop table orders

create table orders(
		o_id int,customer_id int foreign key references customeer(c_id),
		o_amount int,primary key(o_id))

insert into customeer
	values(1,'manish',20,2000),(2,'kshitij',21,1100),(3,'bipin',22,1000),
	(4,'alish',24,500),(5,'bijen',26,5000),(6,'sallu',10,2000),(7,'mohit',24,5000),
	(8,'amrit',18,4000),(9,'niraj',15,2000),(10,'diwas',20,1200)

insert into orders
	values (101,1,2000),(102,2,1500),(103,3,2000),(104,6,1400),(105,8,1200)

 select * from customeer
	where C_salary >5000

update customeer
set c_salary=1.25*c_salary
where c_age>20

select * from customeer as c, orders as o
	where c.c_id=o.customer_id and c.c_age=20

select min(c_salary) as salary,c_age from customeer group by c_age

select top 5 * from customeer

update customeer
set c.c_age = 1.25*c.c_salary
where  in (select o_amount from orders where o_amount>10000)