~/ learn/ comp-378/ cards/ Aggregate Functions: COUNT, SUM, AVG, MIN, MAX (and the three COUNTs)
1 of 5

How many DIFFERENT employees are assigned to at least one project? (Count distinct people in the assignments table.)

space to flip

How many DIFFERENT employees are assigned to at least one project? (Count distinct people in the assignments table.)

Answer

SELECT COUNT(DISTINCT emp_id) AS people_assigned FROM assignments

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/098c0936-de00-4cb8-bca7-91d26a30aa91/flashcard utf-8 LF