2. Find the total percentage of time assigned to employee Abe Advice. Solve it two ways: A) using only WHERE-based join (i.e., no INNER/OUTER/CROSS JOIN) and 2) using some form of JOIN.

3. Find the descriptions of all projects that require more than 70% of an employees time. Solve it two ways: A) using only WHERE-based join (i.e., no INNER/OUTER/CROSS JOIN) B) using some form of JOIN.

4. For each employee ID, find the last name of all employees making more money than that employee. Solve it two ways: A) using only WHERE-based join (i.e., no INNER/OUTER/CROSS JOIN) B) using some form of JOIN.

5. Rank the projects by revenue. Solve it two ways: A) using only WHERE-based join (i.e., no INNER/OUTER/CROSS JOIN) B) using some form of JOIN

24 Chapter l: Databasics projects departments code ? -| projectid deptcodeEK name description managerid FK startdate | ?subdeptof eFK workson projectidrevenue employeeidx assignedtime enddate employees ? employeed? firstname lastname deptcode K salary Figure 1.5: Schema for the Employees Database