SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE MOVIES_SINGLETABLE(IMDBRating FLOAT,YearReleased INT, genres VARCHAR(100)
   ,MPAARating VARCHAR(100))
INSERT INTO MOVIES_SINGLETABLE
VALUES (8.0, 2009, 'Adventure, Fantasy','G,PG-13'),
   (9.0, 1999, 'Family','PG')
SELECT * 
FROM MOVIES_SINGLETABLE 
WHERE IMDBRating >= 7.5 AND YearReleased BETWEEN '1980' AND '2020' 
  AND (
      INSTR (genres, 'Adventure') > 0
   OR INSTR (genres,'Family') > 0
   OR INSTR (genres, 'Fantasy') > 0
  )
  AND (
      INSTR (MPAARating, 'G') > 0
   OR INSTR (MPAARating, 'PG') > 0
   OR INSTR (MPAARating, 'PG-13') > 0
  )
ORDER BY IMDBRating DESC, YearReleased DESC;


IMDBRating
YearReleased
genres
MPAARating


9
1999
Family
PG

8
2009
Adventure, Fantasy
G,PG-13