STUDENT

Observe the table STUDENT:

$\backslash$table$[[$StudentID$,$SSN$,$Name,Class$],[$D$111,111-11-1111,$Connor,Freshman$],[$D$222,222-22-2222,$Trevor,Freshman$],[$D$333,333-33-3333,$Connor,Sophomore$],[$D$444,444-44-4444,$Parker,Sophomore$],[$D$555,555-55-5555,$Connor,Sophomore$]]$

How many records will the following query on table STUDENT return?

SELECT $*$ FROM student WHERE name LIKE $\text{'}\%$or$\%\text{'}$

A$.0$

B$.2$

C$.3$

D$.4$