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

android sql database

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Top Android Projects with Source Code

Android projects with source code - Work on real-time android projects. We’ll start project ideas from beginners level and later move to advance projects.

AlaSQL in Action: The JavaScript SQL Database

Overview on AlaSQL, the popular lightweight client-side in memory SQL database, including a real life example of AlaSQL in action. I was surprised to see that there aren’t more posts about this popular lightweight client-side in-memory SQL database online apart from this awesome article I found.

Backup Database using T-SQL Statements

Introduction In this article, We will discuss how to backup our database in MS-SQL Server using T-SQL Statements. We need to use BACKUP DATABASE statement to create full database backup, along with…