[ad_1]
Something like this:
CREATE VIEW GetNumberOfStudentswithMajor
AS
SELECT COUNT(*) FROM dbo.Students where Major1 is not null and Major2 is not null
[ad_2]
solved Total count in sql
[ad_1]
Something like this:
CREATE VIEW GetNumberOfStudentswithMajor
AS
SELECT COUNT(*) FROM dbo.Students where Major1 is not null and Major2 is not null
[ad_2]
solved Total count in sql