-- Yes their is an order 

-- SELECT (Required) 
-- FROM (Required)
-- JOIN (Combines 2 tables based on a column )
-- WHERE (Filtering Rows)
-- GROUP BY (Grouping Values by unique categories - or - groups -)
-- HAVING (Filtering the categories from the GROUP BY - ONLY used with GROUP BY)
-- ORDER BY (Sort values in Ascending -ASC - or descending - DESC - order)
-- LIMIT (Return the Top N Values) -- top 5 limit or top 10 limit 

-- Which rows will always be included in the result set if Table A is inner joined with Table B? 
   -- If I'm doing an inner join, I will only see the match between those two table. 

-- Which rows will always be included in the result set if Table A is Right joined with Table B?  
    -- I will only see the rows that will always be included will be the rows from Table B. So everything from table B