Skip to content

Instantly share code, notes, and snippets.

@pentium10

pentium10/sample_data_for_median2 Secret

Created April 29, 2011 13:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pentium10/25b991396d0dd6968b7e to your computer and use it in GitHub Desktop.
Save pentium10/25b991396d0dd6968b7e to your computer and use it in GitHub Desktop.
Download ZIP
sample_data_for_median2
Raw
sample_data_for_median2
CREATE TABLE IF NOT EXISTS `_temp_total_gallons` (
`readdate` date NOT NULL,
`total_gallons` double(20,2) NOT NULL,
`nr_people` double default NULL,
KEY `i1` (`readdate`,`total_gallons`,`nr_people`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `_temp_total_gallons`
--
INSERT INTO `_temp_total_gallons` (`readdate`, `total_gallons`, `nr_people`) VALUES
('2009-04-14', 2000.00, 4),
('2009-04-14', 6330.00, 4),
('2009-04-14', 6590.00, 4),
('2009-04-14', 6630.00, 4),
('2009-04-14', 6890.00, 4),
('2009-04-14', 7000.00, 4),
('2009-04-14', 7000.00, 4),
('2009-04-14', 7130.00, 4),
('2009-04-14', 7270.00, 4),
('2009-04-14', 7290.00, 4),
('2009-04-14', 7500.00, 4),
('2009-04-14', 7790.00, 4),
('2009-04-14', 8050.00, 4),
('2009-04-14', 8180.00, 4),
('2009-04-14', 8410.00, 4),
('2009-04-14', 8510.00, 4),
('2009-04-14', 8620.00, 4),
('2009-04-14', 8820.00, 4),
('2009-04-14', 8900.00, 4),
('2009-04-14', 8930.00, 4),
('2009-04-14', 9000.00, 4),
('2009-04-14', 9300.00, 4),
('2009-04-14', 9360.00, 4),
('2009-04-14', 9560.00, 4),
('2009-04-14', 9640.00, 4),
('2009-04-14', 10390.00, 4),
('2009-04-14', 10410.00, 4),
('2009-04-14', 10420.00, 4),
('2009-04-14', 10470.00, 4),
('2009-04-14', 10490.00, 4),
('2009-04-14', 10710.00, 4),
('2009-04-14', 12000.00, 4),
('2009-04-15', 1000.00, 4),
('2009-04-15', 1000.00, 4),
('2009-04-15', 1000.00, 4),
('2009-04-15', 1530.00, 4),
('2009-04-15', 1850.00, 4),
('2009-04-15', 2000.00, 4),
('2009-04-15', 2000.00, 4),
('2009-04-15', 2000.00, 4),
('2009-04-15', 2000.00, 4),
('2009-04-15', 2000.00, 4),
('2009-04-15', 2840.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3000.00, 4),
('2009-04-15', 3960.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 4000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5000.00, 4),
('2009-04-15', 5230.00, 4),
('2009-04-15', 5280.00, 4),
('2009-04-15', 5850.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6000.00, 4),
('2009-04-15', 6410.00, 4),
('2009-04-15', 6520.00, 4),
('2009-04-15', 6580.00, 4),
('2009-04-15', 6580.00, 4),
('2009-04-15', 6830.00, 4),
('2009-04-15', 6910.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7000.00, 4),
('2009-04-15', 7700.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8000.00, 4),
('2009-04-15', 8050.00, 4),
('2009-04-15', 8860.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9000.00, 4),
('2009-04-15', 9600.00, 4),
('2009-04-15', 9740.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10000.00, 4),
('2009-04-15', 10590.00, 4),
('2009-04-15', 10810.00, 4),
('2009-04-15', 11000.00, 4),
('2009-04-15', 11000.00, 4),
('2009-04-15', 11000.00, 4),
('2009-04-15', 11000.00, 4),
('2009-04-15', 11000.00, 4),
('2009-04-15', 11000.00, 4),
('2009-04-15', 11000.00, 4),
('2009-04-15', 11000.00, 4),
('2009-04-15', 11660.00, 4),
('2009-04-15', 12000.00, 4),
('2009-04-15', 12000.00, 4),
('2009-04-15', 12000.00, 4),
('2009-04-15', 12000.00, 4),
('2009-04-15', 12000.00, 4),
('2009-04-15', 12250.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13000.00, 4),
('2009-04-15', 13180.00, 4),
('2009-04-15', 13370.00, 4),
('2009-04-15', 13850.00, 4),
('2009-04-15', 14000.00, 4),
('2009-04-15', 14000.00, 4),
('2009-04-15', 14000.00, 4),
('2009-04-15', 14000.00, 4),
('2009-04-15', 14000.00, 4),
('2009-04-15', 14550.00, 4),
('2009-04-15', 14900.00, 4),
('2009-04-15', 15000.00, 4),
('2009-04-15', 15000.00, 4),
('2009-04-15', 15000.00, 4),
('2009-04-15', 15000.00, 4),
('2009-04-15', 15000.00, 4),
('2009-04-15', 15000.00, 4),
('2009-04-15', 15040.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16000.00, 4),
('2009-04-15', 16400.00, 4),
('2009-04-15', 17000.00, 4),
('2009-04-15', 17890.00, 4),
('2009-04-15', 18000.00, 4),
('2009-04-15', 18000.00, 4),
('2009-04-15', 18000.00, 4),
('2009-04-15', 19000.00, 4),
('2009-04-15', 19030.00, 4),
('2009-04-15', 19860.00, 4),
('2009-04-15', 20000.00, 4),
('2009-04-15', 21000.00, 4),
('2009-04-15', 21000.00, 4),
('2009-04-15', 21000.00, 4),
('2009-04-15', 23000.00, 4),
('2009-04-15', 23000.00, 4),
('2009-04-15', 23000.00, 4),
('2009-04-15', 24000.00, 4),
('2009-04-15', 25000.00, 4),
('2009-04-15', 25000.00, 4),
('2009-04-15', 26000.00, 4),
('2009-04-15', 26000.00, 4),
('2009-04-15', 26000.00, 4),
('2009-04-15', 27000.00, 4),
('2009-04-15', 30000.00, 4),
('2009-04-16', 1000.00, 4),
('2009-04-16', 1000.00, 4),
('2009-04-16', 1580.00, 4),
('2009-04-16', 2000.00, 4),
('2009-04-16', 2010.00, 4),
('2009-04-16', 2370.00, 4),
('2009-04-16', 3000.00, 4),
('2009-04-16', 3000.00, 4),
('2009-04-16', 3320.00, 4),
('2009-04-16', 4000.00, 4),
('2009-04-16', 4610.00, 4),
('2009-04-16', 4840.00, 4),
('2009-04-16', 4900.00, 4),
('2009-04-16', 4930.00, 4),
('2009-04-16', 5000.00, 4),
('2009-04-16', 5000.00, 4),
('2009-04-16', 5000.00, 4),
('2009-04-16', 5980.00, 4),
('2009-04-16', 6000.00, 4),
('2009-04-16', 6000.00, 4),
('2009-04-16', 6220.00, 4),
('2009-04-16', 6310.00, 4),
('2009-04-16', 6340.00, 4),
('2009-04-16', 6500.00, 4),
('2009-04-16', 6860.00, 4),
('2009-04-16', 7000.00, 4),
('2009-04-16', 7000.00, 4),
('2009-04-16', 7000.00, 4),
('2009-04-16', 7000.00, 4),
('2009-04-16', 7140.00, 4),
('2009-04-16', 7320.00, 4),
('2009-04-16', 7400.00, 4),
('2009-04-16', 7510.00, 4),
('2009-04-16', 8000.00, 4),
('2009-04-16', 8000.00, 4),
('2009-04-16', 8000.00, 4),
('2009-04-16', 8000.00, 4),
('2009-04-16', 8170.00, 4),
('2009-04-16', 8210.00, 4),
('2009-04-16', 8320.00, 4),
('2009-04-16', 8360.00, 4),
('2009-04-16', 8710.00, 4),
('2009-04-16', 8800.00, 4),
('2009-04-16', 9000.00, 4),
('2009-04-16', 9000.00, 4),
('2009-04-16', 9000.00, 4),
('2009-04-16', 9000.00, 4),
('2009-04-16', 9000.00, 4),
('2009-04-16', 9100.00, 4),
('2009-04-16', 9120.00, 4),
('2009-04-16', 10000.00, 4),
('2009-04-16', 10000.00, 4),
('2009-04-16', 10000.00, 4),
('2009-04-16', 10020.00, 4),
('2009-04-16', 10120.00, 4),
('2009-04-16', 10780.00, 4),
('2009-04-16', 10950.00, 4),
('2009-04-16', 11000.00, 4),
('2009-04-16', 11120.00, 4),
('2009-04-16', 12000.00, 4),
('2009-04-16', 12000.00, 4),
('2009-04-16', 12000.00, 4),
('2009-04-16', 12000.00, 4),
('2009-04-16', 12340.00, 4),
('2009-04-16', 12350.00, 4),
('2009-04-16', 12620.00, 4),
('2009-04-16', 12960.00, 4),
('2009-04-16', 14000.00, 4),
('2009-04-16', 14040.00, 4),
('2009-04-16', 14050.00, 4),
('2009-04-16', 14610.00, 4),
('2009-04-16', 15000.00, 4),
('2009-04-16', 15000.00, 4),
('2009-04-16', 15300.00, 4),
('2009-04-16', 15720.00, 4),
('2009-04-16', 15790.00, 4),
('2009-04-16', 16000.00, 4),
('2009-04-16', 16100.00, 4),
('2009-04-16', 16140.00, 4),
('2009-04-16', 16760.00, 4),
('2009-04-16', 17420.00, 4),
('2009-04-16', 18000.00, 4),
('2009-04-16', 19000.00, 4),
('2009-04-16', 19320.00, 4),
('2009-04-16', 22000.00, 4),
('2009-04-16', 24910.00, 4),
('2009-04-16', 31000.00, 4);
Correct output
2009-04-14 8565.000000
2009-04-15 9000.000000
2009-04-16 9000.000000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment