

Table: Candidate
+-----+---------+
| id | Name |
+-----+---------+
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | D |
| 5 | E |
+-----+---------+
Table: Vote
+-----+--------------+
| id | CandidateId |
+-----+--------------+
| 1 | 2 |
| 2 | 4 |
| 3 | 3 |
| 4 | 2 |
| 5 | 5 |
+-----+--------------+
The id column in both tables is an auto-incrementing primary key.
The CandidateId column in the Vote table refers to the id column in the Candidate table.
Task:
Write an SQL query to find the name of the candidate who received the most votes. In the event of the above example, the query should return:
+------+
| Name |
+------+
| B |
+------+
Notes:
You may assume that there is no tie; in other words, there will be exactly one candidate with the most votes.
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find the Quiet Students in All Exams
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Find Cumulative Salary of an Employee
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Marvel Cities
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Director's Actor
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions
Spotify Sessions