2 ms·

Those -cmd are actually unnecessary, you can do sqlite3 :memory: '.mode csv' '.import taxi.csv taxi' \ 'SELECT passenger_count, COUNT(*), AVG(total_amo

by remram 4y ago

Those -cmd are actually unnecessary, you can do sqlite3 :memory: '.mode csv' '.import taxi.csv taxi' \ 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count'