USE bank -- Using the database / Schema

SELECT * bank.trans -- bank = database . trans = table
         trans_id as transaction_id --as = give a new name to the input

SELECT DISTINCT type -- DISTINCT = Return's all the unique values of the column

LIMIT 5 -- LIMIT = limit's the top 5 row's

ORDER BY -- ordering the columns alphabeticly (special characters appear first)
         -- 'ORDER BY' can be order by multiple columns
ORDER BY (column name) ASC -- ASC = Ascending
ORDER BY (column name) DESC -- DESC = Descending

ORDER BY 1-8 -- best practice in a profissional environment

GROUP BY -- comes before the "ORDER BY" and aggregates and groups the column
         -- with this function we dont need to use the 'DISCTINCT'

WHERE (column) NOT LIKE ' ' -- it gives you the ouput without the space value
WHERE NOT -- it gives you the output without the values in it

HAVING -- its used in between "group by" and "order by" and filtered aggregate functions

USING -- specifies which columns to test for equality when two tables are joined.