Questions from Database Systems

Q: Write a query to display a brand name and the number of

Write a query to display a brand name and the number of products of that brand that are in the database. Sort the output by the brand name. FIGURE P7. 51 Number of products of each brand

Q: Write a query to display the number of products in each category

Write a query to display the number of products in each category that have a water base. FIGURE P7. 52 Number of water-based products in each category

Q: Write a query to display the number of products within each base

Write a query to display the number of products within each base and type combination. FIGURE P7. 53 Number of products of each base and type

Q: Write a query to display the total inventory—that is,

Write a query to display the total inventory—that is, the sum of all products on hand for each brand ID. Sort the output by brand ID in descending order. FIGURE P7. 54 Total invento...

Q: Write a query to display the brand ID, brand name,

Write a query to display the brand ID, brand name, and average price of products of each brand. Sort the output by brand name. (Results are shown with the average price rounded to two decimal places.)...

Q: Write a query to display the department number and most recent employee

Write a query to display the department number and most recent employee hire date for each department. Sort the output by department number. FIGURE P7. 56 Most recent hire in each department

Q: Write a query to display the employee number, first name,

Write a query to display the employee number, first name, last name, and largest salary amount for each employee in department 200. Sort the output by largest salary in descending order. FIGURE P7. 5...

Q: Write a query to display the customer code, first name,

Write a query to display the customer code, first name, last name, and sum of all invoice totals for customers with cumulative invoice totals greater than $1,500. Sort the output by the sum of invoice...

Q: Write a query to display the department number, department name,

Write a query to display the department number, department name, department phone number, employee number, and last name of each department manager. Sort the output by department name. FIGURE P7. 59 D...

Q: Describe the following: TCP/IP, Router, HTML,

Describe the following: TCP/IP, Router, HTML, HTTP, and URL.