Select query to count and sum of record based on Date using GroupBy in SQL Server

Hi Ruben12345,

Refer the below query sample query for your reference. You need to modify the query as per your requirement.

SELECT DISTINCT [date]
,(SELECT COUNT(device_id) FROM sell WHERE [date] = s.[date]) 'total_id'
,(SELECT SUM(qiantity_sold) FROM sell WHERE [date] = s.[date]) 'total_quantity_sold'
,(SELECT COUNT(device_id)/CAST(SUM(qiantity_sold) AS DECIMAL (3,0)) FROM sell WHERE [date] = s.[date]) 'percentage'
FROM sell s

-- OR

SELECT DISTINCT([date]),
COUNT(device_id ) 'total_id',
SUM(quantity_sold) 'total_quantity_sold',
((COUNT(device_id))/CAST(SUM(quantity_sold)AS DECIMAL(3,0))) 'percentage' 
FROM Sell 
GROUP BY [date]

Output

Hi Ruben12345

select distinct(date),sum(quantity_sold)as totalsales,count(device_id )as totalid,((count(device_id))/cast(sum(quantity_sold)as decimal(2,0)))as percentage from temp4 group by date