Question: Write a query to display the largest average product price
Write a query to display the largest average product price of any brand.
Answer to relevant QuestionsWrite a query to display the brand ID, brand name, brand type, and average price of products for the brand that has the largest average productprice.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.What is a CROSS JOIN? Give an example of its syntax.What is an Oracle sequence? Write its syntax.Create the tables. (Use the MS Access example shown in Figure P8.1 to see what table names and attributes touse.)
Post your question