Commit ebd7b0e

mo khan <mo@mokhan.ca>
2025-01-23 20:56:22
Start assignment 5
1 parent 67fc8b2
Changed files (1)
assignments
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: