SQLite Forum

SQL lite irrespective query
Login
```
SELECT shopper_first_name, shopper_surname, shopper_email_address,
       IFNULL(gender, 'Not known' ) AS 'Gender',
       STRFTIME('%d-%m-%Y', date_joined) AS 'date_joined',
       STRFTIME('%Y',date('now'))- STRFTIME('%Y',date(date_of_birth)) AS 'Age'
  FROM shoppers
 WHERE (gender = 'F') OR (gender = 'M' AND date_joined >= '2020-01-01')
ORDER BY gender,Age DESC
; 

```
Should do it.