SQL: SELECT city,country,sum(events) ev FROM `joe` where country like 'ostrava' and action like 'hairdresser_%'  group by 1,2 order by ev desc limit 1
ROWS: 0

SQL: SELECT city,country,sum(events) ev FROM `joe` where city like 'ostrava' and action like 'hairdresser_%'  group by 1,2 order by ev desc limit 1
ROWS: 1
ROW 0: {"city":"Ostrava","country":"Czechia","ev":"1"}

SQL: SELECT 	sVal FROM `joe_settings` where sTopic like 'hairdresser' and sName like 'color'
ROWS: 5
ROW 0: {"sVal":"'25' => '#f2b434'"}
ROW 1: {"sVal":"'>25' => '#990099'"}
ROW 2: {"sVal":"'20' => '#259c5d'"}
ROW 3: {"sVal":"'10' => '#4882ef'"}
ROW 4: {"sVal":"'0' => '#d7483f'"}

SQL: SELECT 	sVal FROM `joe_settings` where sTopic like 'hairdresser' and sName like 'nice'
ROWS: 1
ROW 0: {"sVal":"a Hairdresser (or Barber, Hair stylist, etc.)"}

SQL: SELECT 	sVal FROM `joe_settings` where sTopic like 'hairdresser' and sName like 'niceTagline'
ROWS: 0

SQL: SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action,sum(events) events FROM joe where lower(city) like 'Ostrava' and country like 'Czechia' and action like 'hairdresser_%' group by 1 order by action desc
ROWS: 1
ROW 0: {"action":"0","events":"1"}

SQL: SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action,sum(events) events FROM joe where country like 'Czechia' and action like 'hairdresser_%' group by 1 order by action desc
ROWS: 5
ROW 0: {"action":"30","events":"2"}
ROW 1: {"action":"25","events":"2"}
ROW 2: {"action":"20","events":"6"}
ROW 3: {"action":"10","events":"2426"}
ROW 4: {"action":"0","events":"1071"}

SQL: SELECT region, sum(action*events) action, sum(events) events from (SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action, region,sum(events) events FROM joe where country like 'Czechia' and action like 'hairdresser%' group by 1,2) g group by 1
ROWS: 13
ROW 0: {"region":"Central Bohemian Region","action":"9300","events":"933"}
ROW 1: {"region":"Hradec Kralove Region","action":"30","events":"2"}
ROW 2: {"region":"Karlovy Vary Region","action":"0","events":"1"}
ROW 3: {"region":"Liberec Region","action":"0","events":"2"}
ROW 4: {"region":"Moravian-Silesian Region","action":"0","events":"6"}
ROW 5: {"region":"Olomouc Region","action":"60","events":"3"}
ROW 6: {"region":"Pardubice Region","action":"50","events":"5"}
ROW 7: {"region":"Plzen Region","action":"0","events":"1"}
ROW 8: {"region":"Prague","action":"14955","events":"2543"}
ROW 9: {"region":"South Bohemian Region","action":"0","events":"1"}

SQL: SELECT country, sum(action*events) action, sum(events) events from (SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action, country,sum(events) events FROM joe where country not like '(not set)' and action like 'hairdresser%' group by 1,2) g group by 1 having sum(events)>4
ROWS: 100
ROW 0: {"country":"Algeria","action":"10","events":"40"}
ROW 1: {"country":"Argentina","action":"4210","events":"249"}
ROW 2: {"country":"Armenia","action":"0","events":"321"}
ROW 3: {"country":"Aruba","action":"20","events":"55"}
ROW 4: {"country":"Australia","action":"95735","events":"68880"}
ROW 5: {"country":"Austria","action":"8645","events":"1110"}
ROW 6: {"country":"Bahrain","action":"2880","events":"290"}
ROW 7: {"country":"Bangladesh","action":"55","events":"339"}
ROW 8: {"country":"Belgium","action":"1135","events":"5256"}
ROW 9: {"country":"Bermuda","action":"420","events":"21"}

SQL: SELECT lat, lon,t.city city, sum(action*events) action, sum(events) events from (SELECT CASE
        WHEN LOWER(action) LIKE 'hairdresser_>25' THEN 30
        ELSE CAST(REPLACE(LOWER(action),'hairdresser_','') AS UNSIGNED)
    END AS action, city,sum(events) events FROM joe where country like 'Czechia' and action like 'hairdresser%' group by 1,2) t left join citiesLatLon ltln on t.city = ltln.city where lat is not null and t.city not like '(not set)' group by 1,2,3 having sum(events)>2
ROWS: 1
ROW 0: {"lat":"50.0755381","lon":"14.4378005","city":"Prague","action":"14955","events":"2543"}

SQL: SELECT city,country,sum(events) ev FROM `joe` where country like 'Ostrava' and action like '{$action_string}_%'  group by 1,2 order by ev desc limit 1
ROWS: 0

SQL: SELECT city,country,sum(events) ev FROM `joe` where city like 'Ostrava' and action like '{$action_string}_%'  group by 1,2 order by ev desc limit 1
ROWS: 0

Colorlib app

C

Everything You Need. To Start Selling Online Beautifully

How much do you tip a Hairdresser (or Barber, Hair stylist, etc.)?

In Ostrava, Czechia ?

Sadly, only 0% said they would tip a Hairdresser (or Barber, Hair stylist, etc.).
1 people tip 0%

Find out what to tip your: Hairdresser, food delivery person, taxi driver

In all of Czechia?

Amazingly enough, 69% said they would tip a Hairdresser (or Barber, Hair stylist, etc.).
2 people tip 30% 2 people tip 25% 6 people tip 20% 2426 people tip 10% 1071 people tip 0%

Tipping by state or region

Touch anywhere on the map for stats

We know this becuase you told us!

The data you see here is driven by users like you, answering a simple question on a different website. Do you drink the tap water where you live?

available on Google Store

available on Apple Store

SQL: Select count(distinct country) countries,count(distinct city) cities,sum(case when action not in (select min(action) from joe where  action like 'hairdresser_%') then events else 0 end) as love, sum(events) users from joe where action like 'hairdresser_%' ;
ROWS: 1
ROW 0: {"countries":"145","cities":"4093","love":"304013","users":"699495"}

SQL: SELECT city from (SELECT city,sum(events) FROM ( SELECT * FROM joe) a  left join ( select country country_2  FROM joe  where lower(city) like 'Ostrava'  order by events desc limit 1 ) b   on a.country = b.country_2 where country_2 is not null  and city not like 'Ostrava' and city not like '(not set)' group by 1 order by 2 desc ) yo  limit 25
ROWS: 25
ROW 0: {"city":"Prague"}
ROW 1: {"city":"Slany"}
ROW 2: {"city":"Brno"}
ROW 3: {"city":"Liberec"}
ROW 4: {"city":"Kromeriz"}
ROW 5: {"city":"Podebrady"}
ROW 6: {"city":"Rudna"}
ROW 7: {"city":"Trinec"}
ROW 8: {"city":"Olomouc"}
ROW 9: {"city":"Pilsen"}

SQL: SELECT * FROM joe_serp WHERE city like 'Ostrava'
ROWS: 0

Why even tip?

“ I have been using it for a number of years. I use Colorlib for usability testing. It's great for taking images and making clickable image prototypes that do the job and save me the coding time and just the general hassle of hosting. ”

Aigars Silkalns

Ceo Colorlib

“ I use Colorlib for usability testing. It's great for taking images and making clickable image prototypes that do the job and save me the coding time and just the general hassle of hosting. ”

Jennifer

Developer

“ I have been using it for a number of years. I use Colorlib for usability testing. It's great for taking images and making clickable image prototypes that do the job.”

Helen

Marketer

“ I have been using it for a number of years. I use Colorlib for usability testing. It's great for taking images and making clickable image prototypes that do the job and save me the coding time and just the general hassle of hosting. ”

Henry smith

Developer

SQL: SELECT city from ( SELECT city,sum(events) FROM joe  WHERE city not like '(not set)' and city not like 'Ostrava' group by 1 order by 2 desc  limit 100) c ORDER BY RAND() limit 20
ROWS: 20
ROW 0: {"city":"Liverpool"}
ROW 1: {"city":"Lisbon"}
ROW 2: {"city":"Atlanta"}
ROW 3: {"city":"Vienna"}
ROW 4: {"city":"Vilnius"}
ROW 5: {"city":"Boston"}
ROW 6: {"city":"Helsinki"}
ROW 7: {"city":"Austin"}
ROW 8: {"city":"Denver"}
ROW 9: {"city":"Wellington"}