When creating an Ad-hoc Query, use the fields found under Giving To My Organization in the Field Explorer pane to output Largest Gift, Last Gift, First Gift, Total Giving and Total Number of Gifts information.
1. On the Select filter and output fields tab of your query, click Giving Summary under the Field Explorer pane.
2. Add the desired output from the middle column to the Output pane in the bottom right by dropping and dragging the fields.