Skip to content

Latest commit

 

History

History
10 lines (8 loc) · 411 Bytes

experiments.md

File metadata and controls

10 lines (8 loc) · 411 Bytes

Experiments

Queries

  1. SELECT sum(total_amount) as sum_total_amt FROM dataset WHERE total_amount > 27;
  2. SELECT * FROM dataset;
  3. SELECT * FROM dataset WHERE total_amount > 27;
  4. SELECT * FROM dataset WHERE total_amount > 69;
  5. SELECT total_amount, fare_amount, tips_amount FROM dataset WHERE total_amount > 69;
  6. SELECT total_amount, fare_amount, tips_amount FROM dataset WHERE total_amount > 150;