Order By

First sort by major. If duplicate major, sort by id

  select * from student
  order by major, student_id desc;
  
  select * from student
  order by student_id desc;

limit

  select * from student
  limit 2;

OR

  select * from student
  where major="CSE" or major="EEE";

Not Equal

  select * from student
  where major <> "CSE";

IN

  select * from student
  where name in('jake', 'lira', 'tom');

  select * from student
  where major in ('CSE', 'EEE');