[Solved] Total count in sql

Question

Something like this:

    CREATE VIEW GetNumberOfStudentswithMajor

    AS

    SELECT COUNT(*) FROM dbo.Students where Major1 is not null and Major2 is not null

Accepted Answer

Something like this:

    CREATE VIEW GetNumberOfStudentswithMajor

    AS

    SELECT COUNT(*) FROM dbo.Students where Major1 is not null and Major2 is not null