Consider the data from the two table STUDENT and BRANCH below.

STUDENT_ID	STUDENT_NAME	BR_ID	MARKS
1001	STUDENT1	101	79
1002	STUDENT 2	102	92
1003	STUDENT 3	101	78
1004	STUDENT 4	102	69
1005	STUDENT 5	103	90
1006	STUDENT 6	104	87
1007	STUDENT 7	103	93
1008	STUDENT 8	102	89
1009	STUDENT 9	105	78
1010	STUDENT 10	106	76

BRANCH_ID	BRANCH_NAME
101	COMPUTERS
102	ARTS
103	ELECTRONICS
104	CHEMICAL
105	MECHANICAL

Write a query to retrieve the STUDENT_ID, STUDENT_NAME, STUDENT_NAME, BRANCH_ID, BRANCH_NAME and MARKS by joining the table STUDENTS and BRANCH on BRANCH_ID column.

SELECT STUDENT_ID, STUDENT_NAME, BRANCH_ID, BRANCH_NAME, MARKS FROM STUDENTS, BRANCH WHERE BR_ID = BRANCH_ID

SELECT STUDENT_ID, STUDENT_NAME, BRANCH_ID, BRANCH_NAME, MARKS FROM STUDENTS INNER JOIN BRANCH WHERE BR_ID = BRANCH_ID

SELECT S.STUDENT_ID, S.STUDENT_NAME, B.BRANCH_ID, B.BRANCH_NAME, S.MARKS FROM STUDENTS S, BRANCH B WHERE S.BR_ID = B.BRANCH_ID

SELECT S.STUDENT_ID, S.STUDENT_NAME, B.BRANCH_ID, B.BRANCH_NAME, S.MARKS FROM STUDENTS S INNER JOIN BRANCH B WHERE S.BR_ID = B.BRANCH_ID

All the above 4 queries are correct.