A manager wants only the positions that received more than 100 applications. Which query is correct?

Un responsable ne veut que les postes ayant reçu plus de 100 candidatures. Quelle requête est correcte ?

Answers

ASELECT Position, COUNT(*) FROM Applications WHERE COUNT(*) > 100 GROUP BY Position;SELECT Position, COUNT(*) FROM Applications WHERE COUNT(*) > 100 GROUP BY Position;

BSELECT Position, COUNT(*) FROM Applications GROUP BY Position WHERE COUNT(*) > 100;SELECT Position, COUNT(*) FROM Applications GROUP BY Position WHERE COUNT(*) > 100;

CSELECT Position FROM Applications LIMIT 100;SELECT Position FROM Applications LIMIT 100;

DSELECT Position, COUNT(*) FROM Applications GROUP BY Position HAVING COUNT(*) > 100;SELECT Position, COUNT(*) FROM Applications GROUP BY Position HAVING COUNT(*) > 100;

The answer and explanation are in the full bank.

This question is one of 2,831 in the paid banks. Each comes with the correct answer and the reasoning behind it, not just a mark.

Unlock for 5,000 RWF

MIFOTRA exam practicealigned to Practice set: Database Management·3 marks·Hard

A manager wants only the positions that received more than 100 applications. Which query is correct?

More Database questions