SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE student
	([s_no] varchar(2), [s_name] varchar(4), [s_age] int)
;
	
INSERT INTO student
	([s_no], [s_name], [s_age])
VALUES
	('A1', 'JOHN', 16),
	('A2', 'JOE', 16),
	('A3', 'TONY', 17)
;
3 rows affected

CREATE TABLE subjects
	([s_no] varchar(2), [subject] varchar(7), [score] int)
;
	
INSERT INTO subjects
	([s_no], [subject], [score])
VALUES
	('A1', 'Math', 58),
	('A1', 'History', 70),
	('A2', 'English', 49),
	('A2', 'History', 90),
	('A3', 'Math', 35),
	('A3', 'English', 77)
;
6 rows affected

select student.s_name,student.s_age,subjects.subject
from subjects 
left join student  on subjects.s_no = student.s_no
where subjects.s_no='A2' and subjects.score>='60'


s_name
s_age
subject


JOE
16
History