Querying sqlite from python-step6

I’m in the step 6 ,creating a cursor and running a query and I don’t understand why I have to make a query “select *…” before to select the column that I need, Major in this case.
Anyone can help me,please?