There’s this absolutely marvelous tool that offers Overpass tutorial with a storytelling approach. You get hints at how queries should be modified, and can try them out against real data, progressing as you find new bits of information from OSM data.
Unfortunately, it’s a bit out of date compared to the current live data in the OSM database, and breaks somewhere around step 6.
Still, even if you haven’t used Overpass before, the first five steps can be useful - and maybe the project gets revived :)