From the file located at /path/to/file.csv, cut the first three fields (separated by commas) and use awk to filter the second field for the word "word". Then sort the output by the second field.
cut -f1-3 -d',' /path/to/file.csv | awk -F, '$2 == "word"' | sort -k2