I want to query open opportunities, but do not know the api name of the field. In the Opportunities report one can set Opportunity status in the top middle to be Closed, Closed Won, Open, or Any. StageName does not have the Open value. So the query
"SELECT AccountId, MRR__c, from Opportunity where StageName='Open' returns nothing. Help appreaciated.