Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
1. Winning Candidate
On this page

Problem

Table: Candidate

+-------------+----------+
| Column Name | Type     |
+-------------+----------+
| id          | int      |
| name        | varchar  |
+-------------+----------+
id is the column with unique values for this table.
Each row of this table contains information about the id and the name of a candidate.

Table: Vote

+-------------+------+
| Column Name | Type |
+-------------+------+
| id          | int  |
| candidateId | int  |
+-------------+------+
id is an auto-increment primary key (column with unique values).

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page