Information using Queries Video Lecture | SSC CGL Tier 2 - Study Material, Online Tests, Previous Year

from this table learners I need to
extract the surname and names of those
who have paid between 500 and 1,000
grands inclusive now to extract that
information and need to create a query
before I create the query I must close
the table close now I'm going to create
a query I'm going to base my query on
this table learners add close
I need the surname and name and to
perform the query I need to her money
now I want those who've paid greater
than or equal to 500 land and less than
and equal to 1000 friend I'm going to
run this and check yes this is correct
however I was not asked to show how much
they had paid so I'm going to take off
that sure but I was asked to sort it in
alphabetical order let me run this and
have a look that is incorrect of beta go
order good
now I'm going to save this query I need
to extract some more information I'm
going to create a query query design I'm
going to base it on the table learners
add and close now I need to have same
name name ID great and I need to make a
list of those who paid nothing I need to
sort it up by ID number let me run this
yes those who paid nothing it's been
sorted by ID number I do not need to
display that they've paid nothing I need
their surname name ID and grade let me
go back into design here and I'm going
to deselect sure now I'm going to run
this but I'm going to save this query as
about standing money correct
there are queries done I have extracted
this information
you