Statement Query Builder

how to write this statement http://sqlfiddle.com/#!9/1ec706/26 and get same result using CI4 Query Builder?

https://codeigniter.com/user_guide/datab...ilder.html

Enlightenment  Is  Freedom

how to write this statement http://sqlfiddle.com/#!9/1ec706/26 and get same result using CI4 Query Builder?

https://codeigniter.com/user_guide/datab...ilder.html

I don't need userguide reference, I read the userguide but there is no thing about my question

why the need for builder if you can use raw query too in CI4 .. don't use hard way

$query = $db->query('YOUR QUERY HERE');