query statments

T

tucker

im having trouble understanding how to perform sql statements in
workign past papers.

can anyone help me with tackling these questions

all female students who do not live within 10km of Bristol university
or less than 19 years old?

all students not called Jones or smith or less than 1.75m tall?

rewrite the following statement to perform the same query without the
or statement

age<21 OR sex= "male"

many thanks
 
J

John W. Vinson

im having trouble understanding how to perform sql statements in
workign past papers.

can anyone help me with tackling these questions

all female students who do not live within 10km of Bristol university
or less than 19 years old?

all students not called Jones or smith or less than 1.75m tall?

rewrite the following statement to perform the same query without the
or statement

age<21 OR sex= "male"

many thanks

Are you perhaps just posting class homework in order to get the answers
without being required to think or study? It certainly looks that way.

If not please explain the context.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top