It is salespersons table

This is orders table

using set operators and subqueries techniques we learned, please find out which salesperson are the ones who generated the largest and smallest orders on each date. Display the salespersonID, name, order no, highest on/lowest on, and order date.  It should look like the following picture

 

 

Transcribed Image Text:

Grid salespersons Enter a SQL expression to filter results (use Ctrl+Space) 12 salesperson_id ABC name ABC City 5,001 James Hoog New York 5,002 Neel Diamond Paris London Krakow San Francisco Hartford 1 T Text GUAWN- 2 3 4 5 6 5,003 5,004 5,005 5,006 Lindsey Sterling Michale Holmes Paul Adam Andy Lowell 123 commission_pct 0.15 0.13 0.11 0.14 0.12 0.13 Grid salespersons Enter a SQL expression to filter results (use Ctrl+Space) 12 salesperson_id ABC name ABC City 5,001 James Hoog New York 5,002 Neel Diamond Paris London Krakow San Francisco Hartford 1 T Text GUAWN- 2 3 4 5 6 5,003 5,004 5,005 5,006 Lindsey Sterling Michale Holmes Paul Adam Andy Lowell 123 commission_pct 0.15 0.13 0.11 0.14 0.12 0.13