Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions