lab5, Sql Server - rextester

lab5

create table User_(User_ID char(2), User_Name varchar(20),User_Email varchar(100),User_Join_date varchar(10),User_City_Name varchar(50),User_City_Country varchar(20),
primary Key(User_ID));
insert into User_ values('01','balram','balramchoudhary314@gamil.com','01-03-2019','newai','india');
insert into User_ values('02','tommy','tommy@gamil.com','02-03-2011','jaipur','india');
insert into User_ values('03','roy',null,'01-03-2019','jodhpur','india');
insert into User_ values('04','ram','ram@gamil.com','01-03-2019','newai','india');
insert into User_ values('05','james','james@gamil.com','01-03-2019','newai','india');
insert into User_ values('06','balram',null,'01-03-2018','newai','india');
insert into User_ values('20','balram',null,'01-03-2018','newai','india');
insert into User_ values('21','balram',null,'01-03-2018','newai','india');
insert into User_ values('22','amit','amit@gmail.com','01-03-2018','newai','india');
insert into User_ values('23','nimesh','nimesh@gmial.com','01-03-2018','newai','india');
insert into User_ values('24','annu','annu@gmail.com','01-03-2018','newai','india');
insert into User_ values('25','anuj','anuj@gmail.com','01-03-2018','newai','india');

create table Friend(Friend_ID char(2), Friend_Since varchar(20),Friend_Message_IN_Count varchar(10), Friend_Message_Out_count varchar(10),User_ID char(2));

insert into Friend values('20','02-02-2019','12','100','21');
insert into Friend values('20','02-02-2019','12','100','02');
insert into Friend values('20','02-02-2019','12','100','03');
insert into Friend values('20','02-11-2019','12','100','23');
insert into Friend values('20','02-11-2019','12','100','24');
insert into Friend values('20','02-11-2019','12','100','25');

insert into Friend values('21','03-11-2013','120','101','01');
insert into Friend values('21','03-11-2013','120','101','03');
insert into Friend values('21','03-11-2013','120','101','06');
insert into Friend values('21','02-11-2019','12','100','23');
insert into Friend values('21','02-11-2019','12','100','24');

insert into Friend values('22','02-01-2019','12','120','06');

insert into Friend values('23','02-11-2019','12','100','01');
insert into Friend values('23','02-11-2019','12','100','20');
insert into Friend values('23','02-11-2019','12','100','21');

insert into Friend values('24','04-12-2020','22','300','05');
insert into Friend values('24','02-11-2019','12','100','20');
insert into Friend values('24','02-11-2019','12','100','21');

insert into Friend values('25','02-11-2019','12','100','01');
insert into Friend values('25','02-11-2019','12','100','20');

insert into Friend values('01','02-11-2021','121','100','20');
insert into Friend values('01','02-11-2021','121','100','21');
insert into Friend values('01','02-11-2021','121','100','23');
insert into Friend values('01','02-11-2021','121','100','25');

insert into Friend values('02','02-11-2019','12','100','20');

insert into Friend values('03','02-11-2019','12','100','20');
insert into Friend values('03','02-11-2019','12','100','21');

insert into Friend values('05','02-11-2019','12','100','24');

insert into Friend values('06','02-11-2019','12','100','21');
insert into Friend values('06','02-11-2019','12','100','22');

create table Post(Post_ID char(2), Post_TimeStamp varchar(10), Post_Text varchar(1000), Post_Attachemnt_ID char(2),Post_Attachemnt_Text varchar(100), Post_Attachemnt_Type varchar(100),
Post_Attachemnt_Data varchar(100), Post_User_ID char(2), Post_Like_User_ID char(2), Post_Comment_ID char(2),Post_Comment_User_ID char(2), Post_Comment_Text varchar (100),
Post_Comment_TimeStamp varchar(10), Post_Comment_Like_UserID char(2), Post_Comment_Reply_ID char(2),Post_Comment_Reply_UserID char(2), Post_Comment_Reply_Addressed_to_UserID char(2),
Post_Comment_Reply_Text varchar(1000), Post_Comment_Reply_Time varchar(10),Post_Comment_Reply_Like_UserID char(2));

insert into Post values('11','5:23pm','hello friends','81','how are you','MP4','12-2-2021','01','20','34','21','fine bro','5:42pm','25','44','25','25','thanku bro','5:50pm','20');
insert into Post values('12','5:13pm','hello friends!!','88','how are you !!','MP3','12-2-2021','01','23','34','21','fine bro','5:42pm','25','44','25','23','thanku bro','5:50pm','21');
insert into Post values('13','5:20pm','welcome!!','90','how are you','MP4','12-2-2021','01','21','34','23','fine bro','5:42pm','25','44','25','25','thanku bro','5:50pm','20');
insert into Post values('15','5:20pm','great','81','how are you','MP4','12-2-2021','02','20','34','20','fine bro','5:39pm','20','44','20','20','thanku bro','5:50pm','20');
insert into Post values('16','5:19pm','good evening','81','great','MP4','12-2-2021','20','03','34','01','fine bro','5:42pm','01','44','02','03','thanku bro','5:50pm','01');
insert into Post values('17','5:15pm','good evening','85','how are you','MP4','12-2-2021','22','06','34','06','fine bro','5:40pm','06','44','06','06','thanku bro','5:50pm','06');
insert into Post values('18','5:03pm','good evening','82','enjoy','MP4','12-2-2021','21','06','34','01','fine bro','5:42pm','03','44','06','06','thanku bro','5:49pm','01');
insert into Post values('19','5:01pm','good evening','82','enjoy life','MP3','12-2-2021','25','01','34','01','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','01');
insert into Post values('19','5:01pm','good evening','82','enjoy life','MP3','12-2-2021','25','20','34','20','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','01');
insert into Post values('20','5:01pm','good evening','82','enjoy life','MP4','12-2-2021','20','01','34','01','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','01');
insert into Post values('20','5:01pm','good evening','82','enjoy life','MP3','12-2-2021','20','01','34','01','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','01');
insert into Post values('20','5:01pm','good evening','82','enjoy life','MP4','12-2-2021','20','25','34','03','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','25');
insert into Post values('21','5:01pm','good evening','82','enjoy life','MP3','12-2-2021','25','01','34','01','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','01');
insert into Post values('22','5:01pm','good evening','82','enjoy life','MP3','12-2-2021','24','01','34','01','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','01');
insert into Post values('23','5:01pm','good evening','82','enjoy life','MP3','12-2-2021','23','21','34','01','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','01');
insert into Post values('23','5:01pm','good evening','82','enjoy life','MP3','12-2-2021','23','20','34','01','fine bro','5:41pm','01','44','01','01','thanku bro','5:55pm','01');

select Post_ID
from User_,Friend,Post
where User_.User_ID=Friend.User_ID and
Friend.Friend_ID=Post.Post_User_ID and Friend.User_ID='01'


run \| edit \| history \| help	0