users.sql

SELECT * FROM (
    SELECT *, 
    CASE
    WHEN age < 18 THEN 'Infant'
    WHEN age < 30 THEN 'Young'
    WHEN age < 50 THEN 'Adult'
    ELSE 'Senior'
    END AS age_group
FROM users ) AS age_group_table

WHERE gender = 'F' AND age_group IN ('Young', 'Adult');