sql - finding the mobile model and manufacturer with highest sales

Question

given two tables table 1 - sales_info

• salesid
• sales date
• imei
• price
• discount
• net amount
• customerid
• model_name

table 2 -mobile_master

• imei

• manufacturer

• model_no

• price

  pred sol

    select manufacurer and model_name
    from sales_info INNER JOIN
         mobile_master
    where sales_info.model_name = mobile_master.model_name and mobile_master.model_name
    where (
    Select count(model_name)
    From Sales_info) as t
    Where t.rank = 1)

Find the model name and manufacturer with the highest sales .

question from:https://stackoverflow.com/questions/65641220/finding-the-mobile-model-and-manufacturer-with-highest-sales

Answer 1

try

SELECT mm.model_name, mm.manufacturer, SUM([net amount]) AS Total -- if you need apply discount etc..
FROM sales_info si 
INNER JOIN mobile_master AS mm ON mm.imei = si.imei
GROUP BY mm.model_name, mm.manufacturer
ORDER BY Total DESC