Basicdataretrieval.docx

NAME:__________________________________________

Stud_ID S1001 S1021 S1033 S1005 S1010 S1020 S1034 S1009 S1012 S1003

FirstName LUCY BRYAN CHRISTIAN MICHELLE VANESSA CHARICE MIKE DAVE ALLYSA JAKE

LastName CALMA HIDALGO BASCON GUTIERREZ SANTIAGO PEMPENGCO SANTOS LAYUG TRINIDAD ZYRUS

Course TOURISM IT BA HRM BA TOURISM HRM IT TOURISM IT

DATE:______________________

Age 17 18 17 16 17 17 18 17 16 17

GWA 95.20 90.72 89.60 93.21 91.80 90.83 94.33 97.81 92.62 98.40

Table: STUDENTTBL

Direction: Create and execute the correct query/ies for the ff. given: write your answers (Queries) on a clean piece of paper. Please call the attention of your professor if you’re done for checking. (Queries must be executed all at once, when you’re done.) 1. Display all the records of your table. 2. Display the First name of students on the table whose GWA is 90.83. 3. Display the last name and Age of the students whose ID is S1010 and below. 4. Display the complete information of students whose course is IT. 5. Display the Full Name and Course of Students whose age is older than 17. 6. Display the First Name of Student whose age is 16 with tourism as the course. 7. Display all the info of the students whose ID falls on any of the ff. values: 1001, 1002, 1003, 1009. 8. Display the StudentID, First name and last name of students whose age is 17. 9. Display the Firstname and course of Students who are not enrolled as Tourism. 10. Display the Student ID, Last name and course of Students whose GWA is 90 to 96.