/* SQL Fundamentals
LOGICAL OPERATORS: AND, OR, NOT 
*/


/* Show students in the ITPROS team and with an ISYS major. */

select std_teamID, stdmajor, stdfname, stdlname
from students
where std_teamID = 'ITPROS' 
AND stdmajor = 'ISYS';

/* Verify output for SQL above. */

select std_teamID, stdmajor, stdfname, stdlname
from students
where std_teamID = 'ITPROS';



/* Show students who are majoring computer science (COMPSC) or 
accounting (ACCT). */

select std_teamID, stdmajor, stdfname, stdlname
from students
where stdmajor = 'COMPSC' 
OR stdmajor = 'ACCT';


/* Show students majoring in accounting OR marketing AND that 
are in the ITPROS team OR the SYSDES team.*/

/* version #1 */
select std_teamID, stdmajor, stdfname, stdlname 
from students
where stdmajor = 'ACCT' OR stdmajor = 'MKTG'
AND std_teamID = 'ITPROS' OR std_teamID = 'SYSDES';



/* version #2 */

select std_teamID, stdmajor, stdfname, stdlname 
from students
where (stdmajor = 'ACCT' OR stdmajor = 'MKTG')
AND (std_teamID = 'ITPROS' OR std_teamID = 'SYSDES');


/* Show students who are NOT in ITPROS and NOT in SYSDES. */

select std_teamID, stdmajor, stdfname, stdlname 
from students
where  NOT std_teamID = 'ITPROS' AND NOT std_teamID = 'SYSDES';