SQL less/greater comparison between booleans produces unexpected results

SQL less/greater comparison between booleans produces unexpected results
I hope you found a solution that worked for you 🙂
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA
Thanks to all those great people for their contributions!

(stackoverflow.com/users/483341/smilingthax)smilingthax
(stackoverflow.com/users/436560/lajos-arpad)Lajos Arpad
(stackoverflow.com/users/1863229/tim-biegeleisen)Tim Biegeleisen
(stackoverflow.com/users/10498828/forpas)forpas
A special thanks goes out to the (https://stackoverflow.com/questions/76922245/sql-less-greater-comparison-between-booleans-produces-unexpected-results)Stackexchange community

I wish you all a wonderful day! Stay safe 🙂

mariadb postgresql mysql sql sqlite