Change the Value of Column When Condition is met

Change the Value of Column When Condition is met

I need help to make a query that groups up dates, and then, tell me if in those dates there are Dates with one or more diferent colors and change the value of the column color for those dates:

I need help to make a query that groups up dates, and then, tell me if in those dates there are Dates with one or more diferent colors and change the value of the column color for those dates:

// What I have
    DATE    |  Color  
 23/01/2019 |  BLUE      
 24/01/2019 |  RED       
 24/01/2019 |  RED
 24/01/2019 |  RED
 27/01/2019 |  RED
 27/01/2019 |  GREEN
 28/01/2019 |  PURPLE
 29/01/2019 |  YELLOW
 02/02/2019 |  BROWN
 02/02/2019 |  BLUE
 15/02/2019 |  RED
 17/02/2019 |  RED
 17/02/2019 |  PURPLE
 20/02/2019 |  WHITE
 23/02/2019 |  BLACK
 27/02/2019 |  CYAN


// Output I need DATE | Color
23/01/2019 | BLUE
24/01/2019 | RED 27/01/2019 | MULTIPLE 28/01/2019 | PURPLE 29/01/2019 | YELLOW 02/02/2019 | MULTIPLE 15/02/2019 | RED 17/02/2019 | MULTIPLE 20/02/2019 | WHITE 23/02/2019 | BLACK 27/02/2019 | CYAN

I made a query that groups up the dates and tells me how many colors there is in each event, but not how many different

The query I made is:

SELECT Date, color, COUNT(*) AS ColorCount 
FROM Events 
GROUP BY DataDoc 
HAVING ColorCount > 0

I need this for a calendar app I'm making, and Im using SQLite

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts|Simpliv

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts

Migrate Entity Framework Core to SQL Database on Startup

This ASP.NET Core tutorial explains how to migrate Entity Framework Core to SQL Database on Startup. How to automatically migrate database changes from code in ASP.NET Core using Entity Framework Core from the Startup.cs file. Use the EF Core DB Context Service to automatically migrate database changes.

A Practical Guide to Database Design and Access SQL|Simpliv

Understanding the Concepts of Database design, develop normalized tables, analyse table designs to avoid redundancy and anomalies, write SQL statements to extract and manipulate requests and resolve many inherent problems associated with poor database design.