The on-campus interview (OCI) consist of one hour coding interview with half hour for SQL and the other half hour for python. For SQL, they ask you to write queries that requires the use of SUM, COUNT function and HAVING, WHERE clause. For python, you have to write a function that returns the number of words from a string or a function that returns the substring from a string.