| 0.0006 |
SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay
FROM (`dimLocation`)
JOIN `dimDate` dd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId`
JOIN `dimDate` dd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId`
WHERE `urlState` = 'texas'
AND `urlName` = 'alice-intl'
LIMIT 1
|
| 0.0006 |
SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTemp, AVG(`meanMaxTemp`) AS meanMaxTemp
FROM (`aggMonthly`)
WHERE `monthNo` = 10
AND `locationId` = '2077'
GROUP BY `monthNo`
|
| 0.0003 |
SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTemp, AVG(`meanMaxTemp`) AS meanMaxTemp
FROM (`aggMonthly`)
WHERE `monthNo` = 10
AND `year` = '2011'
AND `locationId` = '2077'
GROUP BY `monthNo`
|
| 0.0014 |
SELECT `maxTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName`
FROM (`aggMonthly`)
JOIN `dimLocation` ON `dimLocation`.`locationId` = `aggMonthly`.`locationId`
JOIN `dimDate` ON `dimDate`.`dateId` = `aggMonthly`.`maxTempDate`
WHERE `aggMonthly`.`locationId` = '2077'
AND `dimDate`.`monthNo` = 10
AND `dimDate`.`year` = '2011'
ORDER BY `maxTemp` desc
LIMIT 1
|
| 0.0006 |
SELECT AVG(`sumRainfall`) AS sumRainfall, AVG(`daysRainfall`) AS daysRainfall, AVG(`daysSnow`) AS daysSnow, AVG(`daysTornado`) AS daysTornado, AVG(`daysThunder`) AS daysThunder, `monthNo`
FROM (`aggMonthly`)
WHERE `monthNo` = 10
AND `locationId` = '2077'
GROUP BY `monthNo`
|
| 0.0003 |
SELECT AVG(`sumRainfall`) AS sumRainfall, AVG(`daysRainfall`) AS daysRainfall, AVG(`daysSnow`) AS daysSnow, AVG(`daysTornado`) AS daysTornado, AVG(`daysThunder`) AS daysThunder, `monthNo`
FROM (`aggMonthly`)
WHERE `monthNo` = 10
AND `year` = '2011'
AND `locationId` = '2077'
GROUP BY `monthNo`
|