Skip to content
Sign in

Films · Computer science · SQL

Prof. Dr. Dirk Schieborn

AM3 Data Analysis and Machine Learning · Reutlingen University

Lecture film · AM3

SQL: Asking a Table Questions

Lecture film · AM3

SQL: Asking a Table Questions

Prof. Dr. Dirk Schieborn

AM3 Data Analysis and Machine Learning · Reutlingen University

WHERE filters rows, GROUP BY forms groups, HAVING filters groups. And a join first combines every row with every row.

heyprof.app/f/am3-sql-erste-abfragen

More films: Signature · Prof. Dr. Dirk Schieborn

Chapter 1 · WHERE filters rows

Try the app yourself

We store questions without any link to you; selected ones appear anonymously as frequent questions.

SQL: Asking a Table Questions

Prof. Dr. Dirk SchiebornAM3 Data Analysis and Machine Learning · Reutlingen University

NewOct 18, 2026 · 5 chapters

An explainer film in five chapters, made from a real lecture: how WHERE filters rows and why text needs quotes, how a query calculates and sorts, how GROUP BY puts rows into bins and HAVING checks whole groups, in which order the database really reads a query, and why two tables without a condition combine every row with every row. Pause anywhere and ask.

How a film works on heyprof

Every film here listens. Pause it, ask it questions and let it continue with your own examples.

  1. PauseTap pause or press the space bar. The film waits right at that moment.
  2. AskTap “Ask” and type what you want to know. The answer comes inside the film, with picture and voice.
  3. Steer itTell it what to show, for example “Do this with z = 2 − 3i”. The film sets up the app and works it out.
  4. Try it yourselfWhile it is paused, drag points and sliders yourself. “Continue” takes you back into the film.

Without an account: five questions per visit. With an account you can also ask by voice.

Comments