Highest Sales in FurnitureYou have a datasheet called Product_details that contains the Product ID and Product names.In the main datasheet, each order has a  Product ID. Using these two datasheets, find the Product name which has the highest sales in the Furniture category.

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.

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

A wholesale furniture company wants to design a data warehouse for the analysis of the company’s situation with respect to the Furniture, Customers and Time. Moreover, the company needs to analyse:• the furniture with respect to its type (chair, table, wardrobe, cabinet. . . ), category (kitchen, living room, bedroom, bathroom, office. . . ) and material (wood, marble. . . )• the customers with respect to their location, by considering at least cities, regions and statesThe main objective of the company is to know at least the quantity, income and discount of its sales.2|Pagea) Identify facts, measures and dimensions to satisfy the main objectives of the company.b) Design a FACT CONSTELLATION schema to analyse the company’s above needs.

TABLE NAME: AGG_ORDERS (Table names are case sensitive)FIELD NAMES: ord_no, purchase_amt, ord_date, cust_id, salesman_idWrite a query to find the maximum purchase amount made by each customer from the 'AGG_ORDERS' table.

Given a table with order details. Please find the table details and sample data below.TABLE NAME: AGG_ORDERS (Table names are case sensitive)FIELD NAMES: ord_no, purchase_amt, ord_date, cust_id, salesman_idWrite a query to find the maximum purchase amount made by each customer from the 'AGG_ORDERS' table.Note: The required input details will be populated in the backend.This is only a sample data.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the customer ID and the corresponding maximum purchase amount as shown below.Customer_ID Amount123 788.50278 975.50367 3000.00456 2065.50567 123.25789 2500.00