Topic: Help with logic of request
Prompt please how correctly to make request
For example, there is a table with 2 columns
Names the Total
Whether it is possible to group the first column through LIKE clause and to count an amount and the total?
For example (does not work):
SELECT ' Sergey ' as [Names], SUM (IFF ([NAMES] LIKE "Sulfurs???", 1,0) as everything], SUM [Total] as [Total]
GROUP BY ' Sergey'
SELECT ' Andrey ' as [Names], SUM (IFF ([NAMES] LIKE "Andr???", 1,0) as Everything], SUM [Total] as [Total]
GROUP BY ' Andrey'
In advance thanks!