There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
the FROM clauses appear to be identical
but the WHERE clauses differ
I'd suggest revising it into a single (compound) where clause
in summary:
where ( all of the first where clause )
or ( all of the 2nd where clause )
or ( all of the 3rd where clause )
or ( all of the 4th where clause )
some elements are common and can be simplified further - but that's how I would go about it