The MWM survey is focused on stars in the Milky Way. For many science cases, the most useful SDSS outputs are summary files containing stellar parameters for each star in the data release.
There is an MDwarf tutorial using the astraAllStarMDwarfType summary file to plot an HR diagram of M dwarfs observed in DR19 and using the astraAllVisitBossNet summary file to compare results between the two pipelines.
There is a tutorial showing the Galactic chemical trends using the astraAllStarASPCAP summary file. Relationships between [Fe/H] and Galactic position, as well as [Fe/H] vs [Mg/Fe] and Galactic position, are shown.
Since MWM provides many different pipeline products, a composite summary file, MWM lite, is provided where the best pipeline for each star is used. A tutorial demonstrating some of these choices is available.
A final tutorial uses the astraAllStarASPCAP summary file to plot an HR diagram of all DR19 APOGEE stars using photometry and astrometry from Gaia DR3.
For anyone who wants to use SDSS spectra directly, there is a notebook that retrieves and plots an APOGEE spectrum and another that showcases a BOSS white dwarf spectrum. Both notebooks show how to use sdss-access to retrieve spectra.
SQL
More information on querying SDSS data via a SQL database can be found on the SQL Examples page.