DQL Reference Matrix

	MSSQL	Snowflake	Databricks	Oracle	MySQL	NetSuite	Postgres	CSV	Salesforce	MSDynamics
USE to pick dataset	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
SELECT or list* of fields	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
COUNT(*)	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
MIN, MAX, SUM, AVG	✓	✓	✓	✓	✓	X	✓	✓	X	X
WHERE condition having comparison, LIKE	✓	✓	✓	✓	✓	✓	✓	✓	✓	X
Combine WHERE conditions with AND, OR	✓	✓	✓	✓	✓	✓	✓	✓	✓	X
INNER, LEFT, RIGHT JOIN	✓	✓	✓	✓	✓	X	✓	X	X	X
LIMIT with OFFSET	✓	✓	✓	✓	✓	✓	✓	✓	✓	✓
ORDER BY	✓	✓	✓	✓	✓	✓	✓	✓	✓	X
GROUP BY	✓	✓	✓	✓	✓	X	✓	X	X	X