Q: List the name of each employee, his or her birth date
List the name of each employee, his or her birth date, the name of his or her manager, and the manager’s birth date for those employees who were born before their manager was born; label the manager’s...
See AnswerQ: Write an SQL query to display the order number, customer number
Write an SQL query to display the order number, customer number, order date, and items ordered for some particular customer.
See AnswerQ: Write an SQL query to display each item ordered for order number
Write an SQL query to display each item ordered for order number 1, its standard price, and the total price for each item ordered.
See AnswerQ: Refer to the employee EER diagram in Figure 3-2.
Refer to the employee EER diagram in Figure 3-2. Make any assumptions that you believe are necessary. Develop a sample definition for each entity type, attribute, and relationship in the diagram. Dat...
See AnswerQ: Write an SQL query to display the total number of employees working
Write an SQL query to display the total number of employees working at each work center (include ID and location for each work center).
See AnswerQ: Write an SQL query that lists those work centers that employ at
Write an SQL query that lists those work centers that employ at least one person who has the skill ‘QC1’.
See AnswerQ: Write an SQL query to total the cost of order number 1
Write an SQL query to total the cost of order number 1.
See AnswerQ: Write an SQL query that lists for each vendor (including vendor
Write an SQL query that lists for each vendor (including vendor ID and vendor name) those materials that the vendor supplies where the supply unit prices is at least four times the material standard p...
See AnswerQ: Calculate the total raw material cost (label TotCost) for each
Calculate the total raw material cost (label TotCost) for each product compared to its standard product price. Display product ID, product description, standard price, and the total cost in the result...
See AnswerQ: For every order that has been received, display the order ID
For every order that has been received, display the order ID, the total dollar amount owed on that order (you’ll have to calculate this total from attributes in one or more tables; label this result T...
See Answer