SQL Server 2019

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

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) 
	Apr 11 2022 16:24:07 
	Copyright (C) 2019 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE Students(Name varchar(25), Course char(5), Grade char(2));


INSERT INTO dbo.Students(name,Course,Grade)
VALUES
('student1','en101','NA'),
('student1','ma101','B'),
('student1','py102','A'),
('student2','en101','NA'),
('student2','ma205','NA'),
('student2','en206','NA'),
('student3','ma101','NA');
7 rows affected

SELECT Name
FROM dbo.Students a
EXCEPT
select Name 
from dbo.Students
where grade != 'NA';


Name


student2

student3


SELECT 
s1.Name,s1.Course,s1.Grade
FROM 
dbo.Students s1
INNER JOIN
(
SELECT a.Name
FROM dbo.Students a
EXCEPT
select b.Name 
from dbo.Students b
where grade != 'NA') as s2 
on s1.Name =s2.Name




Name
Course
Grade


student2
en101
NA

student2
ma205
NA

student2
en206
NA

student3
ma101
NA

Name	Course	Grade
student2	en101	NA
student2	ma205	NA
student2	en206	NA
student3	ma101	NA