Request for GOOD SQL sites the explain Select in Select well with examples

Question

I'm having a really hard time wrapping my head around using this function and when to use it and the logic behind it.

For instance:
/*Select the code which would show the year when neither a Physics or Chemistry award was given */

I do not understand why it's: Where yr NOT (Select the code which shows the years when a Medicine award was given but no Peace or Literature award was )

AND this query ( /*Select the code which would show the year when neither a Physics or Chemistry award was given */)

...contradicts another question that needs the subjs. separated into two Where clauses.

:( HELP, If you have a site that explains the select clauses in great detail with ample examples I would most appreciate it. This is the biggest thing holding me back in SQL.

Answer 1

Actually, the most common start would be:
https://www.w3schools.com/sql/

I have recently found:
https://sqlzoo.net to have a more applied approach.

Also despite my detest towards teradata SQL, it actually has a pretty good documentation with simple examples:
https://info.teradata.com/htmlpubs/DB_TTU_16_00/index.html

Answer 2

SELECT code FROM table_name
WHERE award NOT LIKE '%physics' AND award NOT LIKE '%chemistry';