SQLite Forum

SQL lite irrespective query
Login
> WHERE (gender = 'F') OR (gender = 'M' AND date_joined >= '2020-01-01')

Since the db schema allows for NULL genders, this slight tweak seems appropriate:

```
WHERE (gender = 'F') OR (gender IS NOT 'F' AND date_joined >= '2020-01-01')
```

(Noting that `IS NOT` is required instead of `<>`.)