SQL is a beautiful language that’s highly useful for extracting large amounts of data from large data warehouses.
There are a few cool shorthand you can use to make you’re experience go faster.
Abbreviating Table Shorthand
/* here's how you would normally write a shortcut for a table name */ select * from table as t /* but here's how you can write it without the word as */ select * from table t /* seems a bit silly but if you're writing a lot of code every abbreviation helps, plus it doesn't hamper readability, in my opinion */
Abbreviating Group By and Order By Columns
/* here's how you would normally write out a group by statement */ select column_1, column_2, count(agg_col) from table t group by t.column_1, t.column_2 /* here's how you can speed up the process */ select column_1, column_2, count(agg_col) from table t group by 1, 2 /* it's not as readable, but I feel like it's not too confusing */
Getting Rid of Multiple Or Statements
/* here's how you would normally write out multiple or statements */ select column_1, column_2 from table t where column_1 = 'x' or column_1 = 'y' /* instead you can just do this */ select column_1, column_2 from table t where column_1 in ('x', 'y') /* ok, so this one is more commonly known but if you don't know this trick you can waste a lot of time in my opinion */