TG: sql_for_qa/66

SQL для тестировщика

Какой из следующих SQL запросов выведет число сотрудников в каждом отделе, при этом названия отделов должны быть отсортированы в алфавитном порядке

Anonymous Quiz

SELECT department, COUNT() FROM employees ORDER BY department ASC;

SELECT department, COUNT() FROM employees GROUP BY department ORDER BY department ASC;

SELECT department, COUNT() FROM employees GROUP BY department ORDER BY COUNT() ASC;

SELECT department, COUNT(*) FROM employees GROUP BY department ORDER BY department DESC;

655 answered

www.tg-me.com/kr/SQL для тестировщика/com.sql_for_qa/66

3.0K viewsMar 20, 2023 at 07:20

tg-me.com/sql_for_qa/66

Create: 2023-03-20
Last Update: 2025-07-02 13:48:47

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/66

SQL для тестировщика Telegram | DID YOU KNOW?

Telegram today rolling out an update which brings with it several new features.The update also adds interactive emoji. When you send one of the select animated emoji in chat, you can now tap on it to initiate a full screen animation. The update also adds interactive emoji. When you send one of the select animated emoji in chat, you can now tap on it to initiate a full screen animation. This is then visible to you or anyone else who's also present in chat at the moment. The animations are also accompanied by vibrations. This is then visible to you or anyone else who's also present in chat at the moment. The animations are also accompanied by vibrations.