rank() over (order by bushels asc) as rank, dense_rank() over (order by bushels asc) as dense_rank, row_number() over (order by bushels) as row_number, rank() over ...

COUNT SELECT COUNT(column_name) FROM table_name WHERE condition; Returns number of rows that match the condition SELECT COUNT(dep_id) FROM employees; AVG SELECT AVG(column_name) FROM table_name WHERE ...