SQL

Recommended Readings

Item	Links
Documentation / Tutorials	SQL for Beginners Management Information Systems Careers
Industry / Case-studies
Books
Cheatsheet	https://www.sqltutorial.org/sql-cheat-sheet/ Luke Harrison: https://websitesetup.org/sql-cheat-sheet/

select
from
where
order by [desc]

Google Sheets

Multiple contains

=QUERY(A1:A,"Select * Where not A Matches '.*AB.*|.*DJ.*' ",1)
=query(C323:C335,"Select C where not C contains 'soccer'")
=QUERY(C:C,"Select C Where not C Matches '.*ezoic.*|.*soccer.*' ",1)

Referencing cells in query

query(sheet2!A:G,"select A where G contains '"&L3&"'")

=query(SX_Sessions!$B$2:$E$120, 
"select B,D 
where E ='" &B3&"' 
AND C = '"&$B$1&"'")

Hyperlinks

=IMPORTXML(B3, "//a/@href")