Write a query to display the mobile model name which has made the maximum sales. Give an alias for the maximum sales as "MAX_SALES". Sort the records based on model name in descending order. (Hint:...


Write a query to display the mobile model name which has made the maximum sales. Give an alias for the maximum sales as

Extracted text: Write a query to display the mobile model name which has made the maximum sales. Give an alias for the maximum sales as "MAX_SALES". Sort the records based on model name in descending order. (Hint: Use mobile_master and sales_info tables to retrieve records) Distributor Customer Info Distributor_ID Distributor_Name Address Mobilenumber Email varchar(10) PK varchar(20) varchar(100) number(10) varchar(30) varchar(10) PK Customer_Name varchar(20) varchar(100) number(10) varchar(30) Customer_ID Address Mobile Email Sales_Info Mobile_Master Salesid Sales_Date IME_No totl Price number(10) PK date IME No Model Name Manufacturer varchar(10) PK varchar(20) varchar(20) varchar(10) FK number(10) number(10) number(10) varchar(10) FK Date_Of_Manufac Warranty_in_Years date number(10) number(7,2) varchar(10) FK varchar(10) FK Discount Net Amount Customer_ID Price Distributor_ID Spec No Mobile_Specification varchar(10) PK varchar(20) varchar(20) varchar(20) varchar(20) number(10) Memory_Card_Capacity_GB number(10) varchar(5) varchar(5) varchar(5) varchar(5) varchar(5) varchar(5) varchar(20) number(10) Spec_No Dimension Weight Display_Type Display Size Internal_mem_in_MB PK - Primary Key FK - Foreigh Key Network 3G GPRS EDGE Bluetooth Camera Camera_Quality OS Battery Life_Hrs

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here