14. Group Sold Products By The Date

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Vote For New Content

14. Group Sold Products By The Date

Table of Contents

Contents are not accessible

Problem

Table Activities:

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| sell_date   | date    |
| product     | varchar |
+-------------+---------+
There is no primary key (column with unique values) for this table. It may contain duplicates.
Each row of this table contains the product name and the date it was sold in a market.

Problem Definition

Write a solution to find for each date the number of different products sold and their names.

The sold products names for each date should be sorted lexicographically.

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible