TG: sql_for_qa/823

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

Какое наиболее подходящее решение для выборки имен сотрудников, чья зарплата выше средней зарплаты их собственного отдела?

Anonymous Quiz

Использовать GROUP BY department_id и HAVING salary > AVG(salary).

Применить функцию AVG(salary) OVER (PARTITION BY department_id) в предложении WHERE.

Использовать коррелированный подзапрос в предложении WHERE.

Использовать JOIN с таблицей, содержащей агрегированные средние значения.

Использовать подзапрос с MAX(salary).

246 answered

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

1.1K viewsJun 23 at 05:09

tg-me.com/sql_for_qa/823

Create: 2025-06-23
Last Update: 2025-07-01 03:03:52

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/823

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

Telegram hopes to raise $1bn with a convertible bond private placement

The super secure UAE-based Telegram messenger service, developed by Russian-born software icon Pavel Durov, is looking to raise $1bn through a bond placement to a limited number of investors from Russia, Europe, Asia and the Middle East, the Kommersant daily reported citing unnamed sources on February 18, 2021.The issue reportedly comprises exchange bonds that could be converted into equity in the messaging service that is currently 100% owned by Durov and his brother Nikolai.Kommersant reports that the price of the conversion would be at a 10% discount to a potential IPO should it happen within five years.The minimum bond placement is said to be set at $50mn, but could be lowered to $10mn. Five-year bonds could carry an annual coupon of 7-8%.