Find student whose attendence is less than 75% in subject AC?
select k.studentID, k.PercentageAttd
select a.STUDENTNO as studentID,
(select count(PRESENCE_K)*100 from attendence b1 where b1.PRESENCE_K='P' and STUDENTNO=a.STUDENTNO and subject_k = 'AC')/
(select count(PRESENCE_K) from attendence b2 where STUDENTNO=a.STUDENTNO and subject_k = 'AC') as PercentageAttd
from attendence a) k
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!