All language subtitles for 11. Exercise 3 SELECT & WHERE

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