'query to get statistic data from SQL server
I have a table named total sales. In this table there are sales data like invoice date and branch name that sells the invoice and the quantity.
I am trying to make a query to get total sales for each branch in every single date and my code is below, but when I execute the code the query returns an error and I cannot determine the condition for every column.
my code :
SELECT invoice_date,
COUNT(quantity) AS malqaStore,
COUNT(quantity) AS tahliaStore
FROM total_sales
WHERE branche_name = 'branch1'
AND branche_name = 'branch2'
GROUP BY invoice_date;
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
