/*
 * $Id$
 *
 * This file is part of the Cloud Services Integration Platform (CSIP),
 * a Model-as-a-Service framework, API, and application suite.
 *
 * 2012-2017, OMSLab, Colorado State University.
 *
 * OMSLab licenses this file to you under the MIT license.
 * See the LICENSE file in the project root for more information.
 */
package database;

/**
 *
 * @author rumpal
 */
public class DBQueries {

    public static String ENERGY01(String cropId) {
        return "SELECT wqm_crop_type, wqm_nitrogen_yield FROM wqm_crops "
                + "WHERE wqm_crop_id = (SELECT fk_wqm_crop_id FROM crops WHERE crop_id = '" + cropId + "');";
    }

}