mysql select statements

Job ID: 30637065

Budget: $10 – $20 USD

I have included a .rar file with a table structure for example...
I want 2 separate SQL select statements..

The first one returns the distinct date with duplicates
The second will return the sch_id for each duplicate.

Their is an enclosed READ ME with a description of types of duplicates we look for