Question: List the balance characteristics of the customers who have made
List the balance characteristics of the customers who have made purchases during the current invoice cycle—that is, for the customers who appear in the INVOICE table. The results of this query are shown inFigure.
Answer to relevant QuestionsUsing the results of the query created in Problem provide a summary of customer balance characteristics as shown inFigure.Write 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 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 correlated subquery? Give an example.What is dynamic SQL, and how does it differ from static SQL?
Post your question