0.0007 |
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` = 'south-dakota' AND `urlName` = 'watertown-regional-airport' LIMIT 1
|
0.0020 |
SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTemp, AVG(`meanMaxTemp`) AS meanMaxTemp FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
|
0.0023 |
SELECT MIN(`minTemp`) AS minMin, MAX(`minTemp`) AS maxMin, MIN(`maxTemp`) AS minMax, MAX(`maxTemp`) AS maxMax FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
|
0.0021 |
SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTemp, AVG(`meanMaxTemp`) AS meanMaxTemp FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
|
0.0019 |
SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTemp, AVG(`meanMaxTemp`) AS meanMaxTemp FROM (`aggMonthly`) WHERE `locationId` = '4296' GROUP BY `monthNo`
|
0.0015 |
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` = '4296' ORDER BY `maxTemp` desc LIMIT 1
|
0.0015 |
SELECT `minTemp`, `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`.`minTempDate` WHERE `aggMonthly`.`locationId` = '4296' ORDER BY `minTemp` asc LIMIT 1
|
0.0012 |
SELECT `monthNo`, `year`, `meanMinTemp` FROM (`aggMonthly`) WHERE `locationId` = '4296' ORDER BY `meanMinTemp` LIMIT 5
|
0.0011 |
SELECT `monthNo`, `year`, `meanMaxTemp` FROM (`aggMonthly`) WHERE `locationId` = '4296' ORDER BY `meanMaxTemp` desc LIMIT 5
|
0.1180 |
select min(count_days) as min_days, avg(count_days) as average_days, max(count_days) as max_days from (select year, count(*) as count_days from factDaily fd join dimDate dd on (dd.dateId = fd.DateId) where fd.locationId = 4296 and minTemp <= 32 group by year) as count_freezing
|
0.0432 |
select min(count_days) as min_days, avg(count_days) as average_days, max(count_days) as max_days from (select year, count(*) as count_days from factDaily fd join dimDate dd on (dd.dateId = fd.DateId) where fd.locationId = 4296 and maxTemp <= 32 group by year) as count_freezing
|
0.0025 |
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 `locationId` = '4296' GROUP BY `monthNo`
|
0.0024 |
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 `locationId` = '4296' GROUP BY `monthNo` ORDER BY `sumRainfall` desc LIMIT 1
|
0.0024 |
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 `locationId` = '4296' GROUP BY `monthNo` ORDER BY `daysRainfall` desc LIMIT 1
|
0.0013 |
SELECT `monthNo`, `year`, `sumRainfall` FROM (`aggMonthly`) WHERE `locationId` = '4296' ORDER BY `sumRainfall` desc LIMIT 5
|
0.0013 |
SELECT `monthNo`, `year`, `sumRainfall` FROM (`aggMonthly`) WHERE `locationId` = '4296' ORDER BY `sumRainfall` LIMIT 5
|
0.0025 |
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 `locationId` = '4296' GROUP BY `monthNo` ORDER BY `sumRainfall` asc LIMIT 1
|
0.0025 |
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 `locationId` = '4296' GROUP BY `monthNo` ORDER BY `daysRainfall` asc LIMIT 1
|
0.0016 |
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` = '4296' ORDER BY `maxTemp` desc LIMIT 5
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0004 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0016 |
SELECT `minTemp`, `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`.`minTempDate` WHERE `aggMonthly`.`locationId` = '4296' ORDER BY `minTemp` asc LIMIT 5
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0020 |
SELECT `maxRainfall`, `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`.`maxRainfallDate` WHERE `aggMonthly`.`locationId` = '4296' AND `dimDate`.`monthNo` = '4' ORDER BY `maxRainfall` desc LIMIT 5
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|
0.0005 |
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 `locationId` = '4296' LIMIT 1
|