LoslegenKostenlos loslegen

Working with the modulo

Employees have different Titles. Some are Sales Support Agents and they are responsible for supporting clients with sales. Each Sales Support Agent gets assigned their own set of customers. The company has gone through a restructuring and now there is a new number of Sales Support Agents.

Your manager wants to know if she can equally divide customers amongst the new sales support team so that each agent has the same number of customers. In this exercise, you will answer this question using the MOD() and COUNT() functions.

Diese Übung ist Teil des Kurses

Introduction to Oracle SQL

Kurs anzeigen

Anleitung zur Übung

  • Use a function to find the remainder between to values.
  • The first value should be the number of customers.
  • The second value should be the number of employees who are Sales Support Agents.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

-- Use a function to find the remainder
SELECT ___(___, ___) AS Modulo
-- Value to be divided
FROM (SELECT ___ AS numerator 
      FROM ___)
	-- Divisor
    CROSS JOIN (SELECT ___ AS denominator 
          FROM ___ 
          WHERE ___ = '___')
Code bearbeiten und ausführen