write query codes for to show student results after login session by using collegeID

DROP TABLE IF EXISTS $`$tblresult$`$;

CREATE TABLE IF NOT EXISTS $`$tblresult$`($

$`$id$`$ int NOT NULL,

$`$StudentId$`$ int DEFAULT NULL,

$`$ClassId$`$ int DEFAULT NULL,

$`$SubjectId$`$ int DEFAULT NULL,

$`$quiz$-$number$`$ int DEFAULT NULL,

$`$marks$`$ int DEFAULT NULL,

DROP TABLE IF EXISTS $`$tblclasses$`$;

CREATE TABLE IF NOT EXISTS $`$tblclasses$`($

$`$id$`$ int NOT NULL AUTO$\_$INCREMENT,

$`$ClassName$`$ varchar$(80)$ DEFAULT NULL,

$`$ClassNameNumeric$`$ int NOT NULL,

$`$Section$`$ varchar$(5)$ NOT NULL,

$`$CreationDate$`$ timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$UpdationDate$`$ timestamp NOT NULL DEFAULT $\text{'}0000-00-0000$:$00$:$00\text{'}$ ON UPDATE CURRENT$\_$TIMESTAMP,

PRIMARY KEY $(`$id$`)$

$)$ ENGINE$=$InnoDB AUTO$\_$INCREMENT$=2111113$ DEFAULT CHARSET$=$latin$1$;

DROP TABLE IF EXISTS $`$tblstudents$`$;

CREATE TABLE IF NOT EXISTS $`$tblstudents$`($

$`$StudentId$`$ int NOT NULL AUTO$\_$INCREMENT,

$`$StudentName$`$ varchar$(100)$ NOT NULL,

$`$RollId$`$ varchar$(100)$ NOT NULL,

$`$StudentEmail$`$ varchar$(100)$ NOT NULL,

$`$Gender$`$ varchar$(10)$ NOT NULL,

$`$DOB$`$ varchar$(100)$ NOT NULL,

$`$ClassId$`$ int NOT NULL,

$`$RegDate$`$ timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$UpdationDate$`$ timestamp NULL DEFAULT NULL ON UPDATE CURRENT$\_$TIMESTAMP,

$`$Status$`$ int NOT NULL,

PRIMARY KEY $(`$StudentId$`)$

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$latin$1$;

DROP TABLE IF EXISTS $`$tblsubjects$`$;

CREATE TABLE IF NOT EXISTS $`$tblsubjects$`($

$`$id$`$ int NOT NULL AUTO$\_$INCREMENT,

$`$SubjectName$`$ varchar$(100)$ NOT NULL,

$`$SubjectCode$`$ varchar$(100)$ NOT NULL,

$`$Creationdate$`$ timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

$`$UpdationDate$`$ timestamp NOT NULL DEFAULT $\text{'}0000-00-0000$:$00$:$00\text{'}$ ON UPDATE CURRENT$\_$TIMESTAMP,

PRIMARY KEY $(`$id$`)$

$)$ ENGINE$=$InnoDB AUTO$\_$INCREMENT$=6$ DEFAULT CHARSET$=$latin$1$;