Write a query to display the employee number, last name, e-mail address, title, and department name of each employee whose job title ends in the word “ASSOCIATE.” Sort the output by department name and employeetitle.
Answer to relevant QuestionsWrite 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 brandname.Write a query to display the vendor ID, vendor name, brand name, and number of products of each brand supplied by each vendor. Sort the output by vendor name and then by brandname.What is the difference between UNION and UNION ALL? Write the syntax for each.Given the employee information in Question 1, what is the query output for the MINUS query? (List the query output.)Assuming you completed problem 10, write the query that will list the names and ages of your customers.
Post your question