The query requirement looks incomplete. Try writing it in such a detailed manner that a 12-year-old could use it to manually and correctly pick out the rows it specifies.
Write that as a query which selects the primary keu values of those rows
Check the result row by row to ensure that it captures the requirement perfectly.
You propose to delete rows; make a backup of the table.
Wrote an outer query that deletes rows identified by the above query eg ...
delete *
from practice.listing_analysis
where <name_of_pk_column > in (<above query>)
If you get stuck, post the result of ...
show create table practice.listing_analysis;
... together with the complete requirement and your query so far.