The PART table contains these columns:ID NUMBER(7) PKCOST NUMBER(7,2)PRODUCT_ID NUMBER(7)Evaluate these two SQL statements:1.SELECT ROUND(MAX(cost),2),ROUND(MIN(cost),2),ROUND(SUM(cost),2),ROUND(AVG(cost),2)FROM part;2.SELECT product_id, ROUND(MAX(cost),2),ROUND(MIN(cost),2),ROUND(SUM(cost),2),ROUND(AVG(cost),2)FROM partGROUP BY product_id;How will the results differ?Select one:a.One of the statements will generate an error.b.The results will be the same, but the display will differ.c.Statement 1 will only display one row of results; statement 2 could display more than one.d.Statement 1 will display a result for each part; statement 2 will display a result for each product.

Consider the following table:Product TableColumn NameDataTypeConstraintprod_nameVarchar2(20) prod_idNumber(10)PK Customer TableColumn NameDataTypeConstraintcust_last_nameVarchar2(20) cust_idNumber(10)PKcust_cityVarchar2(20)  Sales TableColumn NameDataTypeConstraintprod_idNumber(10)FKcust_idNumber(10)FKquantity_soldNumber(10,2)  Generate a report that gives details of the customer's last name, name of the product and the quantity sold for all customers in 'Tokyo'.Which two queries give the required result? (Choose two.)Select one or more:a.SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM products p JOIN sales sON(p.prod_id=s.prod_id)JOIN customers cON(s.cust_id=c.cust_id)WHERE c.cust_city='Tokyo';b.SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM products p JOIN sales s JOIN customers cON(p.prod_id=s.prod_id)ON(s.cust_id=c.cust_id)WHERE c.cust_city='Tokyo';c.SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM sales s JOIN products pUSING (prod_id)JOIN customers cUSING (cust_id)WHERE c.cust_city='Tokyo';d.SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM products p JOIN sales sUSING (prod_id)ON(p.prod_id=s.prod_id)JOIN customers cUSING(cust_id)WHERE c.cust_city='Tokyo';

Problem StatementWrite a query to retrieve the seller ID(s) who made the highest total sales based on the total sum of prices for all their sales.Table: Productproduct_id is the primary key of this table. Each row of this table indicates the name and the price of each product. Table: SalesThis table has no primary key, it can have repeated rows. product_id is a foreign key to the Product table. Note: All records are prepopulated.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The result of the query will be the seller ID(s) who achieved the highest total sales based on the cumulative sum of prices for all their sales as shown below.seller_id13

Cost of manufacturing a finished product.Select one:a.Accounting Equationb.Product costsc.Postingd.Trial Balance

Which of the following SQL keywords is used to perform a Cartesian product in SQL?

Write a query to retrieve the seller ID(s) who made the highest total sales based on the total sum of prices for all their sales.Table: Productproduct_id is the primary key of this table. Each row of this table indicates the name and the price of each product. Table: SalesThis table has no primary key, it can have repeated rows. product_id is a foreign key to the Product table. Note: All records are prepopulated.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The result of the query will be the seller ID(s) who achieved the highest total sales based on the cumulative sum of prices for all their sales as shown below.seller_id13