I have little (or no) knowledge in non-relational banks. I need to convert the query below (SQLite) into an equivalent query to be run in MongoDB.
SELECT COUNT(*) FROM match_table
WHERE (home_team_api_id=9991 AND home_team_goal > away_team_goal)
OR (away_team_api_id=9991 AND away_team_goal > home_team_goal);
As I understand it, MongoDB does not accept queries with grouping in parentheses, among other "incompatibilities". Is it possible to perform an equivalent query in MongoDB ?? Thanks for the help!