SQL Playground (runs in your browser)

Please, click on “Load CSV as table ‘data’” to start!

Data schema (click to expand)

col	meaning	example
id	order id	2001
date	order date (YYYY-MM-DD)	2025-08-01
city	PAR / LYO / BER	PAR
seg	sushi / burg / pizza / healthy	sushi
chan	ios / and / web	ios
mem	Uber One member (0/1)	1
stat	deliv / cxl_usr / cxl_rest	deliv
km	distance (km)	3.1
prom	promised minutes	34
act	actual minutes (blank if canceled)	36
net	subtotal minus discounts (€)	21.50
fee	delivery fee (€)	2.90
tip	tip (€)	0.00
tot	net + fee + tip (0 if canceled)	24.40

id,date,city,seg,chan,mem,stat,km,prom,act,net,fee,tip,tot 2001,2025-08-01,PAR,sushi,ios,0,deliv,3.1,34,36,21.50,2.90,0.00,24.40 2002,2025-08-01,PAR,burg,and,1,deliv,2.8,38,35,16.40,0.00,2.00,18.40 2003,2025-08-01,BER,pizza,ios,0,deliv,4.5,42,47,18.20,3.20,0.00,21.40 2004,2025-08-01,LYO,healthy,web,0,deliv,3.9,37,33,24.10,2.50,1.00,27.60 2005,2025-08-01,BER,sushi,and,1,cxl_usr,0.0,30,,0.00,0.00,0.00,0.00 2006,2025-08-01,PAR,pizza,web,0,deliv,1.6,31,28,12.80,2.00,1.00,15.80 2007,2025-08-01,LYO,burg,ios,0,deliv,2.2,35,34,19.90,2.50,0.00,22.40 2008,2025-08-01,BER,healthy,web,1,deliv,5.2,41,40,28.30,0.00,3.00,31.30 2009,2025-08-02,PAR,sushi,web,0,deliv,3.0,34,32,22.40,2.90,0.00,25.30 2010,2025-08-02,BER,burg,and,0,deliv,4.1,40,44,17.60,3.20,1.00,21.80 2011,2025-08-02,LYO,pizza,ios,1,deliv,2.7,33,31,15.10,0.00,2.00,17.10 2012,2025-08-02,PAR,healthy,web,0,deliv,5.0,42,38,26.90,2.50,0.00,29.40 2013,2025-08-02,BER,sushi,ios,0,cxl_rest,0.0,29,,0.00,0.00,0.00,0.00 2014,2025-08-02,LYO,burg,and,0,deliv,3.2,36,39,18.70,2.50,0.00,21.20 2015,2025-08-02,PAR,pizza,web,1,deliv,1.9,31,33,13.50,0.00,1.00,14.50 2016,2025-08-02,BER,healthy,ios,0,deliv,4.8,40,41,27.80,3.00,2.00,32.80 2017,2025-08-03,PAR,sushi,ios,0,deliv,2.6,33,34,20.90,2.50,0.00,23.40 2018,2025-08-03,LYO,healthy,web,1,deliv,4.5,39,36,31.20,0.00,3.00,34.20 2019,2025-08-03,BER,pizza,and,0,deliv,5.5,43,47,19.40,3.20,0.00,22.60 2020,2025-08-03,PAR,burg,web,0,deliv,3.1,36,35,22.10,2.50,1.00,25.60 2021,2025-08-03,BER,sushi,ios,1,deliv,2.3,31,30,16.80,0.00,2.00,18.80 2022,2025-08-03,LYO,pizza,ios,0,cxl_usr,0.0,32,,0.00,0.00,0.00,0.00 2023,2025-08-03,PAR,healthy,and,0,deliv,4.2,40,43,29.50,3.00,0.00,32.50 2024,2025-08-03,BER,burg,web,0,deliv,3.8,37,39,18.30,3.00,1.00,22.30 2025,2025-08-04,PAR,pizza,ios,0,deliv,1.5,30,29,14.20,2.00,0.00,16.20 2026,2025-08-04,LYO,sushi,web,0,deliv,3.3,35,37,21.50,2.50,0.00,24.00 2027,2025-08-04,BER,healthy,and,1,deliv,5.0,41,40,33.40,0.00,4.00,37.40 2028,2025-08-04,PAR,burg,ios,0,deliv,2.0,34,36,19.10,2.50,1.00,22.60 2029,2025-08-04,LYO,pizza,web,0,deliv,2.4,32,34,15.80,2.00,0.00,17.80 2030,2025-08-04,BER,sushi,and,0,cxl_rest,0.0,30,,0.00,0.00,0.00,0.00 2031,2025-08-04,PAR,healthy,web,1,deliv,4.7,42,39,28.70,0.00,2.00,30.70 2032,2025-08-04,BER,burg,ios,0,deliv,3.9,38,37,17.90,3.00,0.00,20.90 2033,2025-08-05,PAR,sushi,and,0,deliv,3.0,33,35,22.60,3.00,0.00,25.60 2034,2025-08-05,LYO,burg,ios,1,deliv,2.2,35,31,19.50,0.00,2.00,21.50 2035,2025-08-05,BER,pizza,web,0,deliv,4.9,42,45,18.90,3.20,0.00,22.10 2036,2025-08-05,PAR,healthy,ios,0,deliv,4.5,40,41,27.20,2.80,2.00,32.00 2037,2025-08-05,BER,sushi,web,0,deliv,2.8,31,29,20.10,3.00,1.00,24.10 2038,2025-08-05,LYO,pizza,and,0,cxl_usr,0.0,32,,0.00,0.00,0.00,0.00 2039,2025-08-05,PAR,burg,web,0,deliv,3.6,36,38,21.30,2.50,0.00,23.80 2040,2025-08-05,BER,healthy,ios,1,deliv,5.3,41,40,32.40,0.00,3.00,35.40 2041,2025-08-06,PAR,pizza,web,0,deliv,2.0,31,33,13.80,2.00,0.00,15.80 2042,2025-08-06,LYO,sushi,ios,0,deliv,3.1,34,34,21.10,2.50,1.00,24.60 2043,2025-08-06,BER,burg,and,0,deliv,4.0,39,41,18.20,3.00,0.00,21.20 2044,2025-08-06,PAR,healthy,web,1,deliv,4.6,42,44,30.80,0.00,4.00,34.80 2045,2025-08-06,BER,pizza,ios,0,deliv,5.1,43,46,19.70,3.20,0.00,22.90 2046,2025-08-06,LYO,sushi,web,0,cxl_rest,0.0,30,,0.00,0.00,0.00,0.00 2047,2025-08-06,PAR,burg,and,0,deliv,3.3,36,35,20.50,2.50,1.00,24.00 2048,2025-08-06,BER,healthy,web,1,deliv,5.0,41,39,31.60,0.00,3.00,34.60

Query gallery: — choose — Member vs non-member City revenue ETA delta by segment

--Member vs non-member: fee & tip (delivered) SELECT mem, ROUND(AVG(fee),2) AS avg_fee, ROUND(AVG(tip),2) AS avg_tip, COUNT(*) AS orders FROM data WHERE stat = 'deliv' GROUP BY mem;