Latest Questions & Answers

Q: Create a trigger named trg_line_prod that will automatically

Create a trigger named trg_line_prod that will automatically update the product quantity on hand for each product sold after a new LINE row is added. Use the Ch08_SaleCo2 database

Q: Create a trigger named trg_line_total to write the

Create a trigger named trg_line_total to write the LINE_TOTAL value in the LINE table every time you add a new LINE row. (The LINE_TOTAL value is the product of the LINE_UNITS and the LINE_PRICE value...

Q: The purchasing manager is still concerned about the impact of price on

The purchasing manager is still concerned about the impact of price on sales. Write a query to display the brand name, brand type, product SKU, product description, and price of any products that are...

Q: One of the purchasing managers is interested in the impact of product

One of the purchasing managers is interested in the impact of product prices on the sale of products of each brand. Write a query to display the brand name, brand type, average price of products of ea...

Q: LargeCo is planning a new promotion in Alabama (AL) and

LargeCo is planning a new promotion in Alabama (AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name, last...

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

Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee 8367...

Q: The Binder Prime Company wants to recognize the employee who sold the

The Binder Prime Company wants to recognize the employee who sold the most of their products during a specified period. Write a query to display the employee number, employee first name, employee last...

Q: Write a query to display the invoice number, line numbers,

Write a query to display the invoice number, line numbers, product SKUs, product descriptions, and brand ID for sales of sealer and top coat products of the same brand on the same invoice. (Figure P8....

Q: Write the SQL command that will delete the newly created TEMP_

Write the SQL command that will delete the newly created TEMP_1 table from the database.

Q: Write a query to display the starting salary for each employee.

Write a query to display the starting salary for each employee. The starting salary would be the entry in the salary history with the oldest salary start date for each employee. Sort the output by emp...