Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

SELECT: Choose Columns and Calculate New Ones

Lesson 1 of 21Lab

All lessons
  1. SELECT: Choose Columns and Calculate New OnesLabFree
  2. WHERE: Keep Only the Rows You NeedLab Locked
  3. AND, OR, NOT and Why Parentheses MatterLab Locked
  4. IN and BETWEEN: Lists and RangesLab Locked
  5. LIKE Patterns: Searching Text with % and _Lab Locked
  6. ORDER BY: Sort Results Your WayLab Locked
  7. LIMIT, TOP and OFFSET: Top-N Lists and PagesLab Locked
  8. DISTINCT: Remove Duplicate RowsLab Locked
  9. NULL: Missing Values, IS NULL and IS NOT NULLLab Locked
  10. NULL in Calculations: COUNT(*) vs COUNT(column), COALESCELab Locked
  11. Aggregate Functions: COUNT, SUM, AVG, MIN, MAXLab Locked
  12. Aggregates with WHERE: Filtered TotalsLab Locked
  13. GROUP BY: One Result Row per GroupLab Locked
  14. GROUP BY Several Columns: Groups That ExistLab Locked
  15. HAVING: Filter Groups After AggregatingLab Locked
  16. The Logical Order of a Query: FROM to LIMITLab Locked
  17. INSERT: Adding Rows to a TableLab Locked
  18. UPDATE: Changing Rows (and Why WHERE Matters)Lab Locked
  19. DELETE: Removing Rows SafelyLab Locked
  20. Debug Lab: Spot and Fix Broken QueriesLab Locked
  21. Final Project: The Monthly Genre ReportLab Locked

You are not signed in — the lab works, but your progress is not saved. Sign up

Lesson 1 of 21 is free. Unlock all 21 hands-on labs, the final exam and your certificate.

Buy course — €9.90
Loading the lab…
Next lesson →