ITM 500 Chapter : week2
3 Dec 2014
School
Department
Course
Professor
Document Summary
-all the columns for all the rows in the student table. ) -stdssn, stdname and stdmajor columns for all the rows in. -all the columns for the student with the ssn 234567890. ) -(i. e. write a query that will display the data in. -all the columns for the student with the name james. ) Select * from student where stdname = "james" List the ssn and name for all students in the. List the ssn, name and major for all students. List the ssn, name, gpa and major for all. - students with a gpa of at least 3. List all details for the students not in. -itm major with a gpa less than 4. Where stdmajor = "itm" and stdgpa < 4. - in either the itm major or have a gpa less than 4. Where stdmajor = "itm" or stdgpa < 4. List all details for the students that are.
