/* SQL Fundamentals
SELECT ... FROM ... WHERE 
*/


/* List students and their team ID.  Sort by team ID. */

select std_teamID, stdmajor, stdfname, stdlname
from students
order by std_teamID;

/* List students and their team ID.  Sort by team ID and major. */

select std_teamID, stdmajor, stdfname, stdlname
from students
order by std_teamID, stdmajor;


/* Another way to identify which columns to sort by using numbers.  */

select stdfname, stdlname, stdmajor, std_teamID
from students
order by 4, 3;



/* Use column aliases column headings in output.  */

select std_teamID "Team", stdmajor "Major",
   stdfname "First Name", stdlname "Last Name"
from students
order by std_teamID, stdmajor;


/* Combine 2 columns into one (concatenate columns).  */

select std_teamID "Team", stdmajor "Major",
   stdfname + ' ' + stdlname "Student"
from students
order by 1, 2;


select std_teamID "Team", stdmajor "Major",
   stdlname + ', ' + stdfname "Student"
from students
order by 1, 2, 3;



/* Add a calculated column. */

select eval_id, eval_score_id, eval_item_id, 
   score, score * .10 "Points Earned"
from eval_items_scores
order by eval_id, eval_score_id, eval_item_id;