Incorrect Syntax error SQL Query

Question

What is wrong with this query? I keep getting an error

Incorrect Syntax near )

Query

SELECT 
    COUNT(*) QUOTECOUNT 
FROM 
    (SELECT DISTINCT 
         FIRSTNAME, LASTNAME, DATEOFBIRTH, ZIPCODE  
     FROM 
         DBO.RATING_INFO 
     WHERE 
         STATE = 'Texas' 
         AND LOB = 'PersonalAuto'
         AND SOURCELASTMODIFIED BETWEEN '2018-05-02 00:00:00' AND '2018-07-03 00:00:00'
         AND REQUESTEDBYAPPLICATION = 'MR' 
         AND EXTERNALPOLICYSUBSOURCE = 'ezlynx');

Answer 1

You just need the subquery alias, but I also gave the count an alias and put State in brackets for good measure. Should not matter on dbms, but I used SQL Server.

SELECT COUNT(*) as QUOTECOUNT 
FROM (
        SELECT DISTINCT FIRSTNAME, LASTNAME, DATEOFBIRTH, ZIPCODE  
        FROM DBO.RATING_INFO 
        WHERE [STATE] = 'Texas' and LOB = 'PersonalAuto'
                                and SOURCELASTMODIFIED BETWEEN '2018-05-02 00:00:00' AND '2018-07-03 00:00:00'
                                and REQUESTEDBYAPPLICATION = 'MR' 
                                and EXTERNALPOLICYSUBSOURCE = 'ezlynx'
    ) c
;