/*--------------------Question 2---------------------------------------------*/
CREATE TABLE Salaries(
CheckNum INTEGER PRIMARY KEY,
Amount DECIMAL(8,2) NOT NULL
);
Insert into Salaries
values(1111,4532),
(1212,12000),
(1234,12000),
(3344,6000),
(4324,7500),
(4555,6000.12),
(9999,12000),
(3347,6000),
(3348,6000);
/*------------------------------query----------------------------*/
Select Amount, count(Amount) as Frequency
From Salaries
Group By Amount
Having count(Amount) =
(Select max(Frequency)
From (Select count(Amount) as Frequency
From Salaries
GROUP By Amount
));
LyotLS0tLS0tLS0tLS0tLS0tLS0tLVF1ZXN0aW9uIDItLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0qLwpDUkVBVEUgVEFCTEUgU2FsYXJpZXMoCkNoZWNrTnVtIElOVEVHRVIgUFJJTUFSWSBLRVksCkFtb3VudCBERUNJTUFMKDgsMikgTk9UIE5VTEwKKTsKCkluc2VydCBpbnRvIFNhbGFyaWVzCnZhbHVlcygxMTExLDQ1MzIpLAooMTIxMiwxMjAwMCksCigxMjM0LDEyMDAwKSwKKDMzNDQsNjAwMCksCig0MzI0LDc1MDApLAooNDU1NSw2MDAwLjEyKSwKKDk5OTksMTIwMDApLAooMzM0Nyw2MDAwKSwKKDMzNDgsNjAwMCk7CgovKi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLXF1ZXJ5LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSovClNlbGVjdCBBbW91bnQsIGNvdW50KEFtb3VudCkgYXMgRnJlcXVlbmN5CkZyb20gU2FsYXJpZXMKR3JvdXAgQnkgQW1vdW50CkhhdmluZyBjb3VudChBbW91bnQpID0gCihTZWxlY3QgIG1heChGcmVxdWVuY3kpCkZyb20gKFNlbGVjdCBjb3VudChBbW91bnQpIGFzIEZyZXF1ZW5jeQpGcm9tIFNhbGFyaWVzCkdST1VQIEJ5IEFtb3VudAopKTsg