Last active
July 8, 2022 14:28
-
-
Save MGCodesandStats/794a7bcccda743315ccfe5c2716608bf to your computer and use it in GitHub Desktop.
Quarterly sales of SUVs and Trucks for Ford Motor Company for the years 2017 and 2021.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| financials=# select * from ford order by year, month; | |
| brand | sales | type | month | year | |
| ----------------------------+--------+--------+-------+------ | |
| Flex | 1796 | SUVs | 3 | 2017 | |
| Edge | 11730 | SUVs | 3 | 2017 | |
| Escape | 28113 | SUVs | 3 | 2017 | |
| Police Interceptor Utility | 3192 | SUVs | 3 | 2017 | |
| Expedition | 5472 | SUVs | 3 | 2017 | |
| Explorer | 20232 | SUVs | 3 | 2017 | |
| F-Series | 81330 | Trucks | 3 | 2017 | |
| E-Series | 4769 | Trucks | 3 | 2017 | |
| Transit | 12167 | Trucks | 3 | 2017 | |
| Transit Connect | 2760 | Trucks | 3 | 2017 | |
| Heavy Trucks | 1355 | Trucks | 3 | 2017 | |
| Escape | 27151 | SUVs | 6 | 2017 | |
| Edge | 13411 | SUVs | 6 | 2017 | |
| Flex | 2018 | SUVs | 6 | 2017 | |
| Explorer | 21304 | SUVs | 6 | 2017 | |
| Police Interceptor Utility | 2981 | SUVs | 6 | 2017 | |
| Expedition | 4801 | SUVs | 6 | 2017 | |
| F-Series | 77895 | Trucks | 6 | 2017 | |
| E-Series | 4951 | Trucks | 6 | 2017 | |
| Transit | 10826 | Trucks | 6 | 2017 | |
| Transit Connect | 3051 | Trucks | 6 | 2017 | |
| Heavy Trucks | 813 | Trucks | 6 | 2017 | |
| Escape | 25575 | SUVs | 9 | 2017 | |
| Edge | 11476 | SUVs | 9 | 2017 | |
| Expedition | 2848 | SUVs | 9 | 2017 | |
| Police Interceptor Utility | 2309 | SUVs | 9 | 2017 | |
| Explorer | 18898 | SUVs | 9 | 2017 | |
| Flex | 1697 | SUVs | 9 | 2017 | |
| Transit Connect | 2362 | Trucks | 9 | 2017 | |
| Heavy Trucks | 605 | Trucks | 9 | 2017 | |
| Transit | 13546 | Trucks | 9 | 2017 | |
| E-Series | 4810 | Trucks | 9 | 2017 | |
| F-Series | 82302 | Trucks | 9 | 2017 | |
| Escape | 26253 | SUVs | 12 | 2017 | |
| Edge | 13660 | SUVs | 12 | 2017 | |
| Flex | 1834 | SUVs | 12 | 2017 | |
| Explorer | 25375 | SUVs | 12 | 2017 | |
| Police Interceptor Utility | 3191 | SUVs | 12 | 2017 | |
| Expedition | 5458 | SUVs | 12 | 2017 | |
| F-Series | 89385 | Trucks | 12 | 2017 | |
| E-Series | 3911 | Trucks | 12 | 2017 | |
| Transit | 12380 | Trucks | 12 | 2017 | |
| Transit Connect | 3973 | Trucks | 12 | 2017 | |
| Heavy Trucks | 1139 | Trucks | 12 | 2017 | |
| EcoSport | 12878 | SUVs | 3 | 2021 | |
| Flex | 0 | SUVs | 3 | 2021 | |
| Edge | 22150 | SUVs | 3 | 2021 | |
| Mustang Mach E | 6614 | SUVs | 3 | 2021 | |
| Escape | 40990 | SUVs | 3 | 2021 | |
| Bronco Sport | 23356 | SUVs | 3 | 2021 | |
| Expedition | 22263 | SUVs | 3 | 2021 | |
| Explorer | 65244 | SUVs | 3 | 2021 | |
| Heavy Trucks | 3623 | Trucks | 3 | 2021 | |
| F-Series | 203797 | Trucks | 3 | 2021 | |
| Ranger | 24166 | Trucks | 3 | 2021 | |
| E-Series | 10573 | Trucks | 3 | 2021 | |
| Transit | 27451 | Trucks | 3 | 2021 | |
| Transit Connect | 7623 | Trucks | 3 | 2021 | |
| Expedition | 7453 | SUVs | 6 | 2021 | |
| EcoSport | 3520 | SUVs | 6 | 2021 | |
| Bronco Sport | 8355 | SUVs | 6 | 2021 | |
| Escape | 8871 | SUVs | 6 | 2021 | |
| Bronco | 801 | SUVs | 6 | 2021 | |
| Mustang Mach E | 2465 | SUVs | 6 | 2021 | |
| Edge | 4082 | SUVs | 6 | 2021 | |
| Flex | 0 | SUVs | 6 | 2021 | |
| Explorer | 9445 | SUVs | 6 | 2021 | |
| Transit Connect | 2680 | Trucks | 6 | 2021 | |
| F-Series | 45673 | Trucks | 6 | 2021 | |
| Ranger | 7101 | Trucks | 6 | 2021 | |
| E-Series | 2127 | Trucks | 6 | 2021 | |
| Transit | 4436 | Trucks | 6 | 2021 | |
| Heavy Trucks | 1112 | Trucks | 6 | 2021 | |
| Bronco | 3396 | SUVs | 9 | 2021 | |
| Expedition | 5884 | SUVs | 9 | 2021 | |
| Explorer | 20092 | SUVs | 9 | 2021 | |
| Flex | 0 | SUVs | 9 | 2021 | |
| Edge | 6738 | SUVs | 9 | 2021 | |
| Mustang Mach E | 1578 | SUVs | 9 | 2021 | |
| Escape | 11462 | SUVs | 9 | 2021 | |
| Bronco Sport | 11686 | SUVs | 9 | 2021 | |
| EcoSport | 1797 | SUVs | 9 | 2021 | |
| F-Series | 63164 | Trucks | 9 | 2021 | |
| Ranger | 5104 | Trucks | 9 | 2021 | |
| Maverick | 506 | Trucks | 9 | 2021 | |
| E-Series | 3227 | Trucks | 9 | 2021 | |
| Transit | 9939 | Trucks | 9 | 2021 | |
| Transit Connect | 384 | Trucks | 9 | 2021 | |
| Heavy Trucks | 1230 | Trucks | 9 | 2021 | |
| Flex | 0 | SUVs | 12 | 2021 | |
| Explorer | 20715 | SUVs | 12 | 2021 | |
| EcoSport | 2992 | SUVs | 12 | 2021 | |
| Bronco Sport | 6278 | SUVs | 12 | 2021 | |
| Escape | 10704 | SUVs | 12 | 2021 | |
| Bronco | 9168 | SUVs | 12 | 2021 | |
| Mustang Mach E | 2349 | SUVs | 12 | 2021 | |
| Edge | 11456 | SUVs | 12 | 2021 | |
| Expedition | 7559 | SUVs | 12 | 2021 | |
| Heavy Trucks | 1483 | Trucks | 12 | 2021 | |
| E-Series | 3806 | Trucks | 12 | 2021 | |
| Transit | 8521 | Trucks | 12 | 2021 | |
| Maverick | 6030 | Trucks | 12 | 2021 | |
| Ranger | 6992 | Trucks | 12 | 2021 | |
| F-Series | 62496 | Trucks | 12 | 2021 | |
| Transit Connect | 2371 | Trucks | 12 | 2021 | |
| (105 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment