Create & Use Custom Controllers and where clause

Question

Im doing the Create & Use Custom Controllers from trailhead on module visual force basics, I do not know what to do but i have an error in my where clause

    //This is my controller

public class NewCaseListController {
    private String tipoCaso = 'New';

    public List<Case> getNewCases(){
        List<Case> lista = Database.query('SELECT Id, CaseNumber FROM Case WHERE Status = New');
        return lista;
    }

}

And my view

---

<apex:page controller="NewCaseListController" >
    <apex:pageBlock>
        <apex:repeat value="{! newcases}" var="case" >
            <ul>
                <apex:outputLink value="/{! case.Id }" ><li>{! case.Id }</li></apex:outputLink>
                <li>{! case.CaseNumber }</li>
            </ul>

        </apex:repeat>
    </apex:pageBlock>

</apex:page>

when preview, says:

expecting a colon, found 'New' An unexpected error has occurred. Your development organization has been notified.

Answer 1

Your SOQL is not properly formatted, the status "new" should be in between quotes

SELECT Id, CaseNumber FROM Case WHERE Status = 'New'

you can always check your soql in your developer console to validate it. you will notice that if you paste your original soql and try it out

SELECT Id, CaseNumber FROM Case WHERE Status = New

you will get an

'Unknown error parsing query'

Answer 2

public with sharing class NewCaseListController {

    public List<Case> getNewCases() {

       string status = 'New';    
        List<Case> results = Database.query(
            'SELECT Id, CaseNumber FROM Case WHERE Status = :status '
        );
        return results;
    }
}