Consider a table called Elections with Columns

CandidatelD, Voter ID$,$ VoteDate. Write a SQL query to

find the candidate who received the highest no of

votes each month.

$--$ Create the Elections table

CREATE TABLE Elections $($

CandidateID INT,

VoterID INT,

VoteDate DATE

$)$;

$--$ Insert sample values into the Elections table

INSERT INTO Elections $($CandidateID$,$ VoterID, VoteDate$)$ VALUES

$(1,101,\text{'}2023-01-05\text{'}),$

$(2,102,\text{'}2023-01-10\text{'}),$

$(1,103,\text{'}2023-02-15\text{'}),$

$(3,104,\text{'}2023-02-20\text{'}),$

$(2,105,\text{'}2023-03-08\text{'}),$

$(1,106,\text{'}2023-03-12\text{'}),$

$(3,107,\text{'}2023-03-25\text{'})$;