Keep going after module 3
In every course the first three modules stay free. Take premium for one course, or for every course together, for a little more.
- SQL, modules 4 to 8: counting and grouping, joins, subqueries, changing data and window functions
- Excel, modules 4 to 8: conditional counting, lookups, text and dates, pivot tables and dynamic arrays
- HTML & CSS, modules 4 to 8: from selectors to flexbox, grid and responsive design Coming soon
- Their final tests and daily challenges, and in SQL also speedruns and query golf
- Lurnie, your AI coach in every lesson: 30 questions a day, answered with fresh examples
- The SQL certificate for your LinkedIn profile
- Whatever you already did and earned stays yours for good
Stuck? Ask Lurnie
Lurnie is your AI coach in every lesson. Ask your question during or after an exercise and get an explanation at your level, straight away.
Lurnie comes with premium, with 30 questions a day.
LurnieYour SQL coach
Why does WHERE email = NULL find no rows at all?
Because NULL isn't a value: it means unknown. Say two customers left their date of birth blank. Are they the same age? Nobody knows, so = NULL is never true either.
That's why you ask differently: IS NULL checks whether a value is missing. Where does that make the difference in your exercise?
29 of 30 questions left todayLurnie can make mistakes.