Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

CASE and IIF: Labels and Conditional Sums

Lesson 14 of 22 Lab 🔒 Locked

Lessons in this course

  1. SELECT, FROM dbo and Calculated ColumnsLabFree
  2. WHERE: Comparisons, BETWEEN and ANDLab Locked
  3. SELECT TOP, ORDER BY and WITH TIESLab Locked
  4. ORDER BY and OFFSET-FETCH PagingLab Locked
  5. NULL, ISNULL and COALESCELab Locked
  6. Variables, Integer Division and ModuloLab Locked
  7. CAST and CONVERT: Types, Truncation and RoundingLab Locked
  8. TRY_CAST: Converting Dirty Data Without ErrorsLab Locked
  9. Dates: GETDATE, MONTH, DATEPART and EOMONTHLab Locked
  10. DATEADD: Due Dates, Return Windows and Month EndsLab Locked
  11. DATEDIFF: Counting Boundaries, Not DurationsLab Locked
  12. String Functions: LEFT, RIGHT, LEN and TRIMLab Locked
  13. CHARINDEX, SUBSTRING and CONCAT vs +Lab Locked
  14. CASE and IIF: Labels and Conditional SumsLab Locked
  15. Aggregates: COUNT, SUM, AVG and the Integer AVG TrapLab Locked
  16. GROUP BY: One Row per GroupLab Locked
  17. HAVING vs WHERE and the Logical Query OrderLab Locked
  18. Grouping by Month and Where Aliases WorkLab Locked
  19. INSERT and IDENTITY: Automatic Keys and GapsLab Locked
  20. UPDATE: Changing Rows SafelyLab Locked
  21. DELETE vs TRUNCATELab Locked
  22. Final Project: Top Customers ReportLab Locked