Revision 617
Added by Aaron Marcuse-Kubitza almost 13 years ago
| verify.ref.sql | ||
|---|---|---|
| 7 | 7 |
SELECT 'each project\'s # locations' AS ___; |
| 8 | 8 |
SELECT |
| 9 | 9 |
CAST(projects.project_id AS char) AS project |
| 10 |
, count(PlotID) AS plots_count
|
|
| 10 |
, count(PlotID) AS locations_count
|
|
| 11 | 11 |
FROM projects |
| 12 | 12 |
JOIN plotMetadata ON plotMetadata.project_id = projects.project_id |
| 13 | 13 |
GROUP BY project |
Also available in: Unified diff
inputs/SALVIAS/verify: Updated to use new names for renamed tables