fork(1) download
copy 
  1. CREATE TABLE test_table
  2. (tname varchar(25),
  3. ttest varchar(25),
  4. tscore float NOT NULL) ;
  5.  
  6. insert into test_table (tname,ttest,tscore) values ('Bob','Test1','97.0'),
  7. ('Bob','Test2','96.5'),
  8. ('Bob','Test3','94.5'),
  9. ('Joe','Test1','96.5'),
  10. ('Joe','Test2','98.5'),
  11. ('Joe','Test3','92.0');
  12.  
  13. select distinct tname, min(tscore) as min_score, max(tscore) as max_score from test_table group by tname;
Success #stdin #stdout 0s 3396KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Bob|94.5|97.0
Joe|92.0|98.5
https://ideone.com/YmHA7x
language:
SQLite (sqlite 3.27.2)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!