DENG100 Workbook Sample
  • Fundamentals of Database Programming Workbook Sample
  • Syllabus
    • About This Workbook
    • Meet Your Instructor
    • Lecture Organization
      • Lecture Structure
      • Lecture
      • Sample Code
      • Side Quests
      • Lab Assignments
      • Lecture Review
    • Quizzes And Exams
      • Exam Gut Check
      • Lecture Quizzes
      • Final Exam
      • Grading
    • Stay Up To Date With MSDS News Sources
    • Setting Up Your Dev Environment
      • Get A Gmail Account
      • Downloading SQL Server
      • Download SQL Server Management Studio
      • Install PyCharm
      • Ancillary Tools
  • Unit 2: Introduction To SQL Fundamentals
    • SQL Language Basics
      • Lecture Slides
        • Code Tutorials
        • SQL Background
        • Writing Analytic Queries
        • Types of SQL Statements
        • Basic Syntax
        • Code Comments
        • The SELECT Clause
        • Column Aliases
        • Built In Functions
        • String Functions
        • The Format Function
        • The FROM Clause
        • Boolean Logic
        • The WHERE Clause
        • Logic Operators
        • The BETWEEN Operator
        • Filtering With Wildcards
        • The IN Operator
        • The ORDER BY Clause
      • Sample Code
        • Hello World
        • Your First Query
        • Aliases
        • String Functions
        • Filtering Data
        • Ordering Data
      • Side Quests
        • T-SQL Reference
      • Lab Assignment #4
        • Lab Overview
        • Task #1
        • Task #2
        • Task #3
        • Task #4
        • Task #5
        • Task #6
        • Task #7
      • Lecture Review
Powered by GitBook
On this page

Was this helpful?

  1. Unit 2: Introduction To SQL Fundamentals
  2. SQL Language Basics
  3. Lab Assignment #4

Task #7

Add a column for yearly income, and then order the dataset by people with the highest income first.

PreviousTask #6NextLecture Review

Last updated 3 years ago

Was this helpful?