Colorama

A sweet & simple demo database...

create database snazzy;
use snazzy;

A couple of tables...


create table color (
    colorID            int         AUTO_INCREMENT NOT NULL PRIMARY KEY
   ,name               varchar(20)
   ,red                int                     
   ,green              int                     
   ,blue               int           
);

A few inserts...


## ---------------------------------------------------------------
insert into color(name, red, green, blue)
                values('fire engine red', 255,  10,  25)
                     ,('watermelon'     , 100, 100,   0)
                     ,('Green Apple'    ,  91, 194,  54)
                     ;
## ---------------------------------------------------------------

#-- What are some good names for some good colors? 
#--  color thesaurus site has some good single word names
#--  some names are built-in to html/css understanding 
#--                  like ... DarkOrchid
#--                  like ... SlateBlue
#--                  like ... DarkSeaGreen
#--                  like ... Crimson versus red
#--  sherwin-williams is a line of paint; they've got millions of names
#--               and an insanely popping round website to show them (ugh!!!)

How hard could it be, right?

Show all the colors.
List names of all colors with red component greater than 200.
List names of all colors with green component equal to blue component.
List names of all colors with red component larger than green component.
Suppose you wanted to keep track of the names of some shapes.
Triangle, Square, FilledRect, AngLine, FunnyFace, ....
What would this table look like?

HARDER
Suppose you wanted to keep track of lots of shapes each with it's own color. There can certainly be more than one of each shape; maybe lots of ... triangles. And multiple shapes can have the same color ... crimson triangle, crimson square, etc.
How would you keep this track of this sort of information in the database above?

List all the shapes by their shape-names and with their color-names. No numbers!
In your command, do not use any MySQL reserved word outside this set
{ SELECT, WHERE, FROM, INTO, AND, OR, NOT }

Output info might look something like the following...
               Note, the last two lines are not in error.  
               There are 2 filled ovals that special color of red.

        triangle    fire engine red
        square      green
        FilledOval  blue
        triangle    red
        triangle    blue
        FilledOval  fire engine red
        FilledOval  fire engine red

Insert a triangle which is 'robin's egg blue' into snazzy database.
Options for a 2nd (& 3rd?) table