A database includes the following tables. Design a query to identify the notebook computers whose condition worsened while they were checked out. The higher the number, the better the condition of the computer. Include the computer's ID, the ID of the employee who checked it out, the date it was checked out, the condition in which it was checked out, the date it was checked back in, and the condition in which it was checked back in. You may either write the query in SQL code or fill in the appropriate fields in the blank QBE design grid that follows the tables. The blank QBE design grid includes the "Total" line in case the query requires it; if the query does not use it, be sure to cross it off.

Question

Quizplus · Accepted Answer

The Answer of A database includes the following tables. Design a query to identify the notebook computers whose condition worsened while they were checked out. The higher the number, the better the condition of the computer. Include the computer's ID, the ID of the employee who checked it out, the date it was checked out, the condition in which it was checked out, the date it was checked back in, and the condition in which it was checked back in. You may either write the query in SQL code or fill in the appropriate fields in the blank QBE design grid that follows the tables. The blank QBE design grid includes the "Total" line in case the query requires it; if the query does not use it, be sure to cross it off.

A Database Includes the Following Tables