#Uber
You’re given a table of Uber rides that contains the mileage and the purpose for the business expense. You’re asked to find business purposes that generate the most miles driven for passengers that use Uber for their business transportation. Find the top 3 business purpose categories by total mileage.
table name: my_uber_drives
Solution:
select top 3 purpose, sum(miles) as totalmiles
from my_uber_drives
where category='Business'
group by purpose
order by totalmiles desc
Output:
SQL Script:
USE [StrataScratch]
GO
CREATE TABLE [dbo].[my_uber_drives](
[start_date] [datetime] NULL,
[end_date] [datetime] NULL,
[category] [varchar](50) NULL,
[start] [varchar](50) NULL,
[stop] [varchar](50) NULL,
[miles] [float] NULL,
[purpose] [varchar](50) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-01T21:11:00.000' AS DateTime), CAST(N'2016-01-01T21:17:00.000' AS DateTime), N'Business', N'Fort Pierce', N'Fort Pierce', 5.1, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-02T01:25:00.000' AS DateTime), CAST(N'2016-01-02T01:37:00.000' AS DateTime), N'Business', N'Fort Pierce', N'Fort Pierce', 5, N'')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-02T20:25:00.000' AS DateTime), CAST(N'2016-01-02T20:38:00.000' AS DateTime), N'Business', N'Fort Pierce', N'Fort Pierce', 4.8, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-05T17:31:00.000' AS DateTime), CAST(N'2016-01-05T17:45:00.000' AS DateTime), N'Business', N'Fort Pierce', N'Fort Pierce', 4.7, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-06T14:42:00.000' AS DateTime), CAST(N'2016-01-06T15:49:00.000' AS DateTime), N'Business', N'Fort Pierce', N'West Palm Beach', 63.7, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-06T17:15:00.000' AS DateTime), CAST(N'2016-01-06T17:19:00.000' AS DateTime), N'Business', N'West Palm Beach', N'West Palm Beach', 4.3, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-06T17:30:00.000' AS DateTime), CAST(N'2016-01-06T17:35:00.000' AS DateTime), N'Business', N'West Palm Beach', N'Palm Beach', 7.1, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-07T13:27:00.000' AS DateTime), CAST(N'2016-01-07T13:33:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 0.8, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-10T08:05:00.000' AS DateTime), CAST(N'2016-01-10T08:25:00.000' AS DateTime), N'Business', N'Cary', N'Morrisville', 8.3, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-10T12:17:00.000' AS DateTime), CAST(N'2016-01-10T12:44:00.000' AS DateTime), N'Business', N'Jamaica', N'New York', 16.5, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-10T15:08:00.000' AS DateTime), CAST(N'2016-01-10T15:51:00.000' AS DateTime), N'Business', N'New York', N'Queens', 10.8, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-10T18:18:00.000' AS DateTime), CAST(N'2016-01-10T18:53:00.000' AS DateTime), N'Business', N'Elmhurst', N'New York', 7.5, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-10T19:12:00.000' AS DateTime), CAST(N'2016-01-10T19:32:00.000' AS DateTime), N'Business', N'Midtown', N'East Harlem', 6.2, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-11T08:55:00.000' AS DateTime), CAST(N'2016-01-11T09:21:00.000' AS DateTime), N'Business', N'East Harlem', N'NoMad', 6.4, N'Temporary Site')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-11T11:56:00.000' AS DateTime), CAST(N'2016-01-11T12:03:00.000' AS DateTime), N'Business', N'Flatiron District', N'Midtown', 1.6, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-11T13:32:00.000' AS DateTime), CAST(N'2016-01-11T13:46:00.000' AS DateTime), N'Business', N'Midtown', N'Midtown East', 1.7, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-11T14:30:00.000' AS DateTime), CAST(N'2016-01-11T14:43:00.000' AS DateTime), N'Business', N'Midtown East', N'Midtown', 1.9, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-12T12:33:00.000' AS DateTime), CAST(N'2016-01-12T12:49:00.000' AS DateTime), N'Business', N'Midtown', N'Hudson Square', 1.9, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-12T12:53:00.000' AS DateTime), CAST(N'2016-01-12T13:09:00.000' AS DateTime), N'Business', N'Hudson Square', N'Lower Manhattan', 4, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-12T14:42:00.000' AS DateTime), CAST(N'2016-01-12T14:56:00.000' AS DateTime), N'Business', N'Lower Manhattan', N'Hudson Square', 1.8, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-12T15:13:00.000' AS DateTime), CAST(N'2016-01-12T15:28:00.000' AS DateTime), N'Business', N'Hudson Square', N'Hell''s Kitchen', 2.4, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-12T15:42:00.000' AS DateTime), CAST(N'2016-01-12T15:54:00.000' AS DateTime), N'Business', N'Hell''s Kitchen', N'Midtown', 2, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-12T16:02:00.000' AS DateTime), CAST(N'2016-01-12T17:00:00.000' AS DateTime), N'Business', N'New York', N'Queens County', 15.1, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-13T13:54:00.000' AS DateTime), CAST(N'2016-01-13T14:07:00.000' AS DateTime), N'Business', N'Downtown', N'Gulfton', 11.2, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-13T15:00:00.000' AS DateTime), CAST(N'2016-01-13T15:28:00.000' AS DateTime), N'Business', N'Gulfton', N'Downtown', 11.8, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-14T16:29:00.000' AS DateTime), CAST(N'2016-01-14T17:05:00.000' AS DateTime), N'Business', N'Houston', N'Houston', 21.9, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-14T21:39:00.000' AS DateTime), CAST(N'2016-01-14T21:45:00.000' AS DateTime), N'Business', N'Eagan Park', N'Jamestown Court', 3.9, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-15T00:41:00.000' AS DateTime), CAST(N'2016-01-15T01:01:00.000' AS DateTime), N'Business', N'Morrisville', N'Cary', 8, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-15T11:43:00.000' AS DateTime), CAST(N'2016-01-15T12:03:00.000' AS DateTime), N'Business', N'Cary', N'Durham', 10.4, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-15T13:26:00.000' AS DateTime), CAST(N'2016-01-15T13:44:00.000' AS DateTime), N'Business', N'Durham', N'Cary', 10.4, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-18T14:55:00.000' AS DateTime), CAST(N'2016-01-18T15:06:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 4.8, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-18T16:13:00.000' AS DateTime), CAST(N'2016-01-18T16:24:00.000' AS DateTime), N'Business', N'Farmington Woods', N'Whitebridge', 4.7, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-19T09:09:00.000' AS DateTime), CAST(N'2016-01-19T09:23:00.000' AS DateTime), N'Business', N'Whitebridge', N'Lake Wellingborough', 7.2, N'')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-19T10:55:00.000' AS DateTime), CAST(N'2016-01-19T11:09:00.000' AS DateTime), N'Business', N'Lake Wellingborough', N'Whitebridge', 7.6, N'Temporary Site')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-20T10:36:00.000' AS DateTime), CAST(N'2016-01-20T11:11:00.000' AS DateTime), N'Business', N'Cary', N'Raleigh', 17.1, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-20T11:48:00.000' AS DateTime), CAST(N'2016-01-20T12:19:00.000' AS DateTime), N'Business', N'Fayetteville Street', N'Umstead', 15.1, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-20T13:25:00.000' AS DateTime), CAST(N'2016-01-20T14:19:00.000' AS DateTime), N'Business', N'Raleigh', N'Cary', 40.2, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-21T14:25:00.000' AS DateTime), CAST(N'2016-01-21T14:29:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 1.6, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-21T14:43:00.000' AS DateTime), CAST(N'2016-01-21T14:51:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 2.4, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-21T16:01:00.000' AS DateTime), CAST(N'2016-01-21T16:06:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 1, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-26T10:41:00.000' AS DateTime), CAST(N'2016-01-26T10:50:00.000' AS DateTime), N'Business', N'Whitebridge', N'Hazelwood', 2, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-26T12:33:00.000' AS DateTime), CAST(N'2016-01-26T12:41:00.000' AS DateTime), N'Business', N'Hazelwood', N'Whitebridge', 2.3, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-26T16:24:00.000' AS DateTime), CAST(N'2016-01-26T16:32:00.000' AS DateTime), N'Business', N'Whitebridge', N'Westpark Place', 1.9, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-26T17:17:00.000' AS DateTime), CAST(N'2016-01-26T17:22:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 1.4, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-26T17:27:00.000' AS DateTime), CAST(N'2016-01-26T17:29:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 0.5, N'Errand/Supplies')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-27T09:24:00.000' AS DateTime), CAST(N'2016-01-27T09:31:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 1.8, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-27T10:19:00.000' AS DateTime), CAST(N'2016-01-27T10:48:00.000' AS DateTime), N'Business', N'Cary', N'Raleigh', 18.7, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-27T12:34:00.000' AS DateTime), CAST(N'2016-01-27T12:44:00.000' AS DateTime), N'Business', N'Fairmont', N'Meredith Townes', 3.4, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-27T14:05:00.000' AS DateTime), CAST(N'2016-01-27T14:13:00.000' AS DateTime), N'Business', N'Raleigh', N'Raleigh', 2.7, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-27T14:46:00.000' AS DateTime), CAST(N'2016-01-27T15:08:00.000' AS DateTime), N'Business', N'Raleigh', N'Cary', 12.9, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-28T12:28:00.000' AS DateTime), CAST(N'2016-01-28T13:00:00.000' AS DateTime), N'Business', N'Cary', N'Raleigh', 19, N'Temporary Site')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-28T15:11:00.000' AS DateTime), CAST(N'2016-01-28T15:31:00.000' AS DateTime), N'Business', N'Meredith Townes', N'Leesville Hollow', 14.7, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-28T16:21:00.000' AS DateTime), CAST(N'2016-01-28T16:51:00.000' AS DateTime), N'Business', N'Raleigh', N'Cary', 15.7, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-29T09:31:00.000' AS DateTime), CAST(N'2016-01-29T09:45:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 4.6, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-29T10:56:00.000' AS DateTime), CAST(N'2016-01-29T11:07:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 5.2, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-29T11:43:00.000' AS DateTime), CAST(N'2016-01-29T12:03:00.000' AS DateTime), N'Business', N'Cary', N'Durham', 10.4, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-29T13:24:00.000' AS DateTime), CAST(N'2016-01-29T13:47:00.000' AS DateTime), N'Business', N'Durham', N'Cary', 10.1, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-29T21:21:00.000' AS DateTime), CAST(N'2016-01-29T21:40:00.000' AS DateTime), N'Business', N'Apex', N'Cary', 5.5, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-01-30T18:09:00.000' AS DateTime), CAST(N'2016-01-30T18:24:00.000' AS DateTime), N'Business', N'Apex', N'Cary', 5.7, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-01T10:35:00.000' AS DateTime), CAST(N'2016-02-01T11:15:00.000' AS DateTime), N'Business', N'Cary', N'Chapel Hill', 19.4, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-01T12:10:00.000' AS DateTime), CAST(N'2016-02-01T12:43:00.000' AS DateTime), N'Business', N'Chapel Hill', N'Cary', 23.3, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-01T12:56:00.000' AS DateTime), CAST(N'2016-02-01T13:07:00.000' AS DateTime), N'Business', N'Northwoods', N'Whitebridge', 3.9, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-02T13:04:00.000' AS DateTime), CAST(N'2016-02-02T13:23:00.000' AS DateTime), N'Business', N'Whitebridge', N'Williamsburg Manor', 8.3, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-04T09:37:00.000' AS DateTime), CAST(N'2016-02-04T10:09:00.000' AS DateTime), N'Business', N'Morrisville', N'Cary', 9.7, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-04T10:26:00.000' AS DateTime), CAST(N'2016-02-04T10:32:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 1.6, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-04T15:59:00.000' AS DateTime), CAST(N'2016-02-04T16:03:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 1.1, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-04T16:35:00.000' AS DateTime), CAST(N'2016-02-04T16:39:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 1.6, N'Meal/Entertain')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-04T18:04:00.000' AS DateTime), CAST(N'2016-02-04T18:31:00.000' AS DateTime), N'Business', N'Whitebridge', N'Macgregor Downs', 9, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-04T20:36:00.000' AS DateTime), CAST(N'2016-02-04T20:55:00.000' AS DateTime), N'Business', N'Cary', N'Cary', 7.7, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-05T11:47:00.000' AS DateTime), CAST(N'2016-02-05T12:07:00.000' AS DateTime), N'Business', N'Cary', N'Durham', 10.4, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-05T13:22:00.000' AS DateTime), CAST(N'2016-02-05T13:41:00.000' AS DateTime), N'Business', N'Durham', N'Cary', 10.4, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-06T16:20:00.000' AS DateTime), CAST(N'2016-02-06T16:53:00.000' AS DateTime), N'Business', N'Cary', N'Raleigh', 11.4, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-07T18:03:00.000' AS DateTime), CAST(N'2016-02-07T18:17:00.000' AS DateTime), N'Business', N'Apex', N'Cary', 5.7, N'Customer Visit')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-07T18:39:00.000' AS DateTime), CAST(N'2016-02-07T18:53:00.000' AS DateTime), N'Business', N'Cary', N'Morrisville', 6.1, N'Temporary Site')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-07T20:22:00.000' AS DateTime), CAST(N'2016-02-07T20:40:00.000' AS DateTime), N'Business', N'Morrisville', N'Cary', 6.1, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-09T10:54:00.000' AS DateTime), CAST(N'2016-02-09T11:07:00.000' AS DateTime), N'Personal', N'Whitebridge', N'Northwoods', 5.3, N'')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-09T11:43:00.000' AS DateTime), CAST(N'2016-02-09T11:50:00.000' AS DateTime), N'Personal', N'Northwoods', N'Tanglewood', 3, N'')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-09T13:36:00.000' AS DateTime), CAST(N'2016-02-09T13:52:00.000' AS DateTime), N'Personal', N'Tanglewood', N'Preston', 5.1, N'')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-11T18:24:00.000' AS DateTime), CAST(N'2016-02-11T18:46:00.000' AS DateTime), N'Business', N'Raleigh', N'Morrisville', 13.5, N'Temporary Site')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-11T20:36:00.000' AS DateTime), CAST(N'2016-02-11T20:51:00.000' AS DateTime), N'Business', N'Morrisville', N'Cary', 6.1, N'Temporary Site')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-12T13:02:00.000' AS DateTime), CAST(N'2016-02-12T13:36:00.000' AS DateTime), N'Business', N'Raleigh', N'Cary', 18, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-12T14:49:00.000' AS DateTime), CAST(N'2016-02-12T15:06:00.000' AS DateTime), N'Business', N'Cary', N'Morrisville', 8.4, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-13T14:21:00.000' AS DateTime), CAST(N'2016-02-13T14:41:00.000' AS DateTime), N'Business', N'Cary', N'Morrisville', 8.9, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-14T14:07:00.000' AS DateTime), CAST(N'2016-02-14T14:40:00.000' AS DateTime), N'Business', N'East Elmhurst', N'New York', 8.1, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-14T14:46:00.000' AS DateTime), CAST(N'2016-02-14T15:03:00.000' AS DateTime), N'Business', N'Midtown', N'Midtown West', 2, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-02-14T16:35:00.000' AS DateTime), CAST(N'2016-02-14T17:02:00.000' AS DateTime), N'Business', N'New York', N'Long Island City', 13, N'Meeting')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-03-07T15:19:00.000' AS DateTime), CAST(N'2016-03-07T15:45:00.000' AS DateTime), N'Business', N'Raleigh', N'Cary', 11.9, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-03-08T14:38:00.000' AS DateTime), CAST(N'2016-03-08T14:55:00.000' AS DateTime), N'Business', N'Whitebridge', N'Waverly Place', 7.2, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-04-24T21:41:00.000' AS DateTime), CAST(N'2016-04-24T21:50:00.000' AS DateTime), N'Business', N'Morrisville', N'Cary', 4.2, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-04-27T13:30:00.000' AS DateTime), CAST(N'2016-04-27T13:40:00.000' AS DateTime), N'Business', N'Whitebridge', N'Burtrose', 4.9, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-04-27T14:13:00.000' AS DateTime), CAST(N'2016-04-27T14:25:00.000' AS DateTime), N'Business', N'Burtrose', N'Whitebridge', 4.8, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-05-01T17:33:00.000' AS DateTime), CAST(N'2016-05-01T17:45:00.000' AS DateTime), N'Business', N'Whitebridge', N'Tanglewood', 6.2, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-05-09T14:39:00.000' AS DateTime), CAST(N'2016-05-09T15:06:00.000' AS DateTime), N'Business', N'San Francisco', N'Palo Alto', 20.5, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-06-03T22:47:00.000' AS DateTime), CAST(N'2016-06-03T23:06:00.000' AS DateTime), N'Business', N'Morrisville', N'Cary', 4, N'Between Offices')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-07-17T11:23:00.000' AS DateTime), CAST(N'2016-07-17T11:50:00.000' AS DateTime), N'Personal', N'Banner Elk', N'Boone', 15.1, N'Charity ($)')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-07-17T12:20:00.000' AS DateTime), CAST(N'2016-07-17T15:25:00.000' AS DateTime), N'Personal', N'Boone', N'Cary', 180.2, N'Commute')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-08-21T10:00:00.000' AS DateTime), CAST(N'2016-08-21T10:29:00.000' AS DateTime), N'Business', N'Unknown Location', N'Unknown Location', 7.6, N'Airport/Travel')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-12-17T15:38:00.000' AS DateTime), CAST(N'2016-12-17T16:12:00.000' AS DateTime), N'Business', N'Unknown Location', N'Unknown Location', 4.8, N'Airport/Travel')
GO
INSERT [dbo].[my_uber_drives] ([start_date], [end_date], [category], [start], [stop], [miles], [purpose]) VALUES (CAST(N'2016-12-29T13:56:00.000' AS DateTime), CAST(N'2016-12-29T14:11:00.000' AS DateTime), N'Business', N'Kar?chi', N'Kar?chi', 4.1, N'Airport/Travel')
GO