diff options
| author | mo khan <mo@mokhan.ca> | 2025-01-23 13:56:22 -0700 |
|---|---|---|
| committer | mo khan <mo@mokhan.ca> | 2025-01-23 13:56:22 -0700 |
| commit | ebd7b0ed66fc9a13aac5bbcb93e461002abd5995 (patch) | |
| tree | 56a75bcbba0a8f0097b556dd9af712eee31ba0ce | |
| parent | 67fc8b2aa13eafb028397fdd7e8e94cca342d76a (diff) | |
Start assignment 5
| -rw-r--r-- | assignments/5-solution.md | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/assignments/5-solution.md b/assignments/5-solution.md index 6d5c2ca..327bde1 100644 --- a/assignments/5-solution.md +++ b/assignments/5-solution.md @@ -27,6 +27,38 @@ computer modeling. Chapter 14: +> 4. Using the Employees table of Figure 14.6, what is the result of the +> following SQL query? `SELECT * FROM Employees WHERE HoursWorked < 100;` + +Figure 14.6 + +```plaintext +Employees + +| ID | LastName | FirstName | Birthdate | PayRate | HoursWorked | +| -- | -------- | --------- | --------- | ------- | ----------- | +| 116 | Kay | Janet | 3/22/1976 | $16.60 | 94 | +| 123 | Perreira | Francine | 8/15/1989 | $8.50 | 185 | +| 149 | Takasano | Frederick | 5/23/1986 | $12.35 | 250 | +| 171 | Kay | John | 11/17/1984 | $17.80 | 245 | +| 165 | Honou | Morris | 6/9/1993 | $6.70 | 53 | +``` + +The result of executing the query is: + +```sql +SELECT * +FROM Employees +WHERE HoursWorked < 100; +``` + +``` +| ID | LastName | FirstName | Birthdate | PayRate | HoursWorked | +| -- | -------- | --------- | --------- | ------- | ----------- | +| 116 | Kay | Janet | 3/22/1976 | $16.60 | 94 | +| 165 | Honou | Morris | 6/9/1993 | $6.70 | 53 | +``` + Chapter 15: Chapter 16: |