Original subtitles

0 Hi everyone 1

We have learnt the fundamental queries in SQL. It is now time to test what we have learnt 2

First thing we have to do is, we'll have to retrieve all data from the 3

Table science class 4

This should be simple 5

Now let us put some filter on it 6

I want you to retrieve only name of students who have scored more than 60 marks 7

Not all the columns only name of students 8

who have scored 9

More than 60 marks 10

Next 11

Retrieve 12

All data of students 13

Who have scored more than 35 but less than 60 marks 14

probably you are already guessing that it will have two conditions 15

And you know 16

What operator to use when you want to add 17

More than one condition 18

Next is you want to get all other students 19

so, all the list that you got in point 3 20

You want to get 21

Any other student who was not part of that previous list 22

These are students who have scored less than or equal to 35 23

or more than or equal to 60 marks 24

Try this out 25

If you are able to do it great 26

Revisit the video if you are not able to do it