Project

General

Profile

« Previous | Next » 

Revision 617

Added by Aaron Marcuse-Kubitza almost 13 years ago

inputs/SALVIAS/verify: Updated to use new names for renamed tables

View differences:

inputs/SALVIAS/verify.ref
29 29 
9
30 30 
___
31 31 
each project's # locations
32 
project	plots_count
32 
project	locations_count
33 33 
1	228
34 34 
10	22
35 35 
11	12962
inputs/SALVIAS/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