Question: Write a query to display a brand name and the
Write 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.
Answer to relevant QuestionsWrite 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 CROSS JOIN? Give an example of its syntax.Why does the order of the operands (tables) matter in a MINUS query but not in a UNION query?What Oracle function should you use to calculate the number of days between the current date and January 25, 1999?Write the trigger to update the CUST_BALANCE in the CUSTOMER table when a new invoice record is entered. (Assume that the sale is a credit sale.) Test the trigger using the following new INVOICE record:8005, 1001, ...
Post your question