yc.qry.sql

select avg(tip_amount) from "nyc-yellowcab" where tip_amount > 0;
select count(*), vendorid from "nyc-yellowcab" group by vendorid;
select avg(tip_amount), vendorid from "nyc-yellowcab" where tip_amount > 0 group by 2;
select avg(cast(passenger_count as integer)) from "nyc-yellowcab";
select passenger_count, avg(tip_amount) from "nyc-yellowcab" where tip_amount > 0 group by passenger_count order by 1;
select passenger_count, count(*) from "nyc-yellowcab" group by passenger_count order by 1;