create database EffectiveWing

create table student
(
	ID int IDENTITY(1,1) PRIMARY KEY,
	firstName varchar(50),
	lastName varchar(50),
	age int,
	staddress varchar(200),
	moduleID varchar(20)
);

 delete student

insert into student
(ID, firstName, lastName,age, staddress,moduleID) values
(1	,'Amo','	Jarry', 	32	,'Durban  4001','	APPDEV201');

update student
set ID = 1
where firstname = 'Amo';

update student
set firstName = 'Mac'
where ID = 5;

delete student where ID=4;

select * from student;

select ID, firstName, lastName,age, staddress,moduleID, 'App Dev' as Module
from student
order by(ID);


SELECT ID, 'App Dev' as Module
FROM student
where ID=5
order by(ID);