Write a query to display the manager name, department name, department phone number, employee name, customer name, invoice date, and invoice total for the department manager of the employee who made a sale to a customer whose last name is Hagan on May 18, 2011. For all person names, concatenate the first and last names into a singlefield.
Answer to relevant QuestionsWrite the SQL code to delete the row for the person named William Smithfield, who was hired on June 22, 2004, and whose job code classification is 500. 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 decimalplaces.)What is a subquery, and what are its basic characteristics?What is a stored procedure, and why is it particularly useful? Give an example.Write the query that will show only the duplicate customer records.
Post your question