Databases Question
View this question.
Add this question to a group or test by clicking the appropriate button below.
Note: This question is included in a group. The contents of the question may require the group's common instructions or reference text to be meaningful. If so, you may want to add the entire group of questions to your test. To do this, click on the group instructions in the blue box below. If you choose to add only this question, common instructions or reference text will not be added to your test.
Answer these questions using your knowledge of SQL, Relational Database Management Systems (e.g. MySQL, SQL Server, Oracle, etc.) and the sample table below.
| Colors | |
|---|---|
| id | color |
| 1 | Red |
| 2 | Blue |
| 3 | Red |
| 4 | Green |
| 5 | Blue |
| 6 | Red |
| 7 | Orange |
Write a query to count the number of times each color appears in the table Colors. Your output should look like this:
| color | count |
|---|---|
| Blue | 2 |
| Green | 1 |
| Orange | 1 |
| Red | 3 |