Let's imagine that your employer asked you to analyze what type of chocolate sells better. You need to create a SELECT query with two columns: name and sale. The query should take information from the chocolate_sales table.
Value of name column simply recorded in the table. To create sale column, you need to divide data by color column and summarize sales values.