Latest Questions & Answers

Q: Write a query to display the book title, year, and

Write a query to display the book title, year, and subject for every book. Sort the results by book subject in ascending order, year in descending order, and then title in ascending order (See Figure...

See Answer

Q: Write a query to display the checkout number, book number,

Write a query to display the checkout number, book number, patron ID, checkout date, and due date for every checkout that has ever occurred in the system. Sort the results by checkout date in descend...

See Answer

Q: Write a query to display the book number, title, and

Write a query to display the book number, title, and cost of each book (See Figure P7.71). FIGURE P7. 71 Title and Replacement Cost for Books

See Answer

Q: Generate a listing of all purchases made by the customers, using

Generate a listing of all purchases made by the customers, using the output shown in Figure P7.28 as your guide. (Hint: Use the ORDER BY clause to order the resulting rows as shown in Figure P7.28)...

See Answer

Q: Write a query to display the different subjects on which FACT has

Write a query to display the different subjects on which FACT has books. Include each subject only once (See Figure P7.70). FIGURE P7. 70 Unique Book Subjects

See Answer

Q: Write a query to display the different years that books have been

Write a query to display the different years that books have been published in. Include each year only once (See Figure P7.69). FIGURE P7. 69 Unique Book Years

See Answer

Q: Write a query to display the book number, book title,

Write a query to display the book number, book title, and year of publication for every book (See Figure P7.68). FIGURE P7. 68 Title and Year for all Books

See Answer

Q: Write the SQL code that will change the PROJ_NUM to

Write the SQL code that will change the PROJ_NUM to 14 for those employees who were hired before January 1, 1994 and whose job code is at least 501. ATTRIBUTE (FIELD) NAME DATA DECLARATION  EMP_N...

See Answer

Q: Using a single command sequence, write the SQL code that will

Using a single command sequence, write the SQL code that will change the project number (PROJ_NUM) to 25 for all employees whose job classification (JOB_CODE) is 502 or higher. When you finish Problem...

See Answer

Q: Using a single command sequence, write the SQL code that will

Using a single command sequence, write the SQL code that will change the project number (PROJ_NUM) to 18 for all employees whose job classification (JOB_CODE) is 500. ATTRIBUTE (FIELD) NAME DATA DEC...

See Answer