Дана таблица:
ID | GENDER | DEPARTMENT | PURCHASES |
---|---|---|---|
1 | female | housewares | 27.75 |
2 | male | garden | 42.20 |
3 | female | home improvement | 97.50 |
4 | female | kitchen/bathroom | 28.60 |
5 | male | furniture | 225.75 |
6 | female | garden | 34.40 |
7 | male | hardware | 16.50 |
SELECT department, COUNT(*) FROM customers WHERE gender LIKE '%male' AND purchases > 30.00 GROUP BY department ORDER BY 1;Количество строк, возвращенных запросом, =...
(Отметьте один правильный вариант ответа.)
Варианты ответа
0
3(Верный ответ)
4
2
5