-- The APOGEE survey is conducted along a number of different lines of sight,
-- each referred to as as a "field" or "location" (interchangeably). Each
-- field has a name and an id number (LOCATION_ID). The stars in each field
-- are observed multiple times on multiple visits, on different MJDs. These
-- may involve one or more physical plug plates.
-- To find all the plate visits, one can search as follows (for LOCATION_ID
-- 4105):

SELECT plate, mjd FROM apogeePlate WHERE location_id=4105

-- The same field can be searched by its name (in this case 'M13'):

SELECT plate, mjd FROM apogeePlate WHERE name = 'M13'
