diff options
| -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: |