Question: Question 10 (10 points) Saved Based on student table, what is the meaning of following statement? Select stu_fname from student where SCHLRSHP > 1000 and
Question 10 (10 points) Saved Based on student table, what is the meaning of following statement? Select stu_fname from student where SCHLRSHP > 1000 and home_state = 'TX'; Show full name of students those who are living in TX and having at least $1001 scholarship. Show only first name of students those who are living in TX and having at least $1001 scholarship Show students information of those who are living in TX and having $1000 scholarship Show only first name of students those who are living in TX and having $1000 scholarship +T SID FNAME STATE ZIP SCHOLARSHIP LNAME White Edit - Copy Delete 1 John MI 15642 1000 Edit Copy Delete 2 Davis Brown CA 52188 c Tim TX 75102 1500 Osbourn TX 77586 1500 Williams TX 77586 500 Page NY 10210 1000 Wooden LA 36541 1500 Edit Hi Copy Delete 3 Wong Edit - Copy Delete 4 Kerry Edit : Copy Delete 5 Doug Edit Copy Delete 6 Tim Edit Copy Delete Beth Edit Copy Delete 8 Charlie Edit : Copy Delete 9 Mike Edit Copy Delete 10 Bernard Edit : Copy Delete 11 Tim Edit Copy Delete 12 Albert Edit Copy Dolote 13 Diano Edit Copy Doloto 14 Cheryl Pott NM 48576 1500 Henderson OK 65214 300 Paterson TX 73405 1500 Wilson TX 77766 2000 Kennedy TX 77766 1500 Page AR 72120 400 Lee TX 73130 1200 t_O Check all With selected: Edit Copy Deleto Export
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
