Data Science Interview Questions: Parts of a SQL Query

A common question I have seen good people get tripped up on. Remember KISS – Keep it Simple Stupid.

Don’t let the question trick you into overthinking. For a SQL query you need a SELECT command (what do we want), a FROM (what table is it in) and if you want to go for the extra credit point, throw in a WHERE (its our filter)

Return to questions page

Real Data Science Interview Questions: Question 1

Explain the difference between Regression and a Classifier:

Link to video

While regression and classifiers are both popular machine learning model types, the difference sits in the results they return:

Regression returns distinct values: think height of a person, price of a house, weight of truck

Classifiers return categories: tall / short, expensive/mid-ranged/cheap, heavy/light

Return to interview questions