nashmaniac · July 28, 2022 04:02
diff --git a/basic-sql-construct.sql b/basic-sql-construct.sql
 SELECT -- required, contains column names comma separated, if you need everything then use *
 FROM -- required, name of the sheet
 WHERE -- optional, generally contains the filtering criteria
 ORDER BY -- optional, used for sorting. Default is low to high. if high to low needed use `desc`
 GROUP BY -- optional, used for pivot table kind of query
 HAVING -- optional, filtering on the group by
	SELECT -- required, contains column names comma separated, if you need everything then use *
	FROM -- required, name of the sheet
	WHERE -- optional, generally contains the filtering criteria
	ORDER BY -- optional, used for sorting. Default is low to high. if high to low needed use `desc`
	GROUP BY -- optional, used for pivot table kind of query
	HAVING -- optional, filtering on the group by