91Ó°ÊÓ

Consider the Company database and its Employee table. 1\. The empId field is assigned values sequentially starting at 1. What is the last empId value that was used? (What is the empId for the last employee added to the table?) 2\. Write a query to determine the name of the oldest employee. 3\. Write a query to list all of the employee last names. If at least two employees have the same last name then this list will be shorter that a list of employees. 4\. Suppose there is a field hireDate which holds the date when an employee was hired. Write a query to determine the name of the employee who was most recently hired?

Consider the Genealogy database. 1\. Create a query with two parameters: a start date and an end date. The query will list all persons whose birth dates fall in the range from start date to end date.

Consider the library database. 1\. Create a query that will list every book and the date it was borrowed. Include all books in your result. 2\. Create a query to list every library member and the dates they borrowed books. Include all members 3\. Try creating a query that will list books that have never been borrowed. 4\. Try creating a query to list any members who have not borrowed a book.