Original subtitles

0 Hi everyone 1

Now that we know about the date time functions 2

Let's try to find out the age of Batman who was born on April 6th 1939 3

I want you to find out the years months and days 4

From this date 5

In the next activity 6

You'll have to analyze and find out the monthly sales of 7

Chair subcategory 8

What I mean is 9

in the resultset I want you to get 10

the sales of 11

Chair subcategory 12

For each month 13

so your result set should have the 12 months 14

And against those 12 months it should contain the sum of 15

Sales for those 12 months for the subcategory chair in the year 2015 16

Once you have done this try to find out if there is any pattern 17

I am not sure if there is actually any pattern 18

But 19

once we run this query 20

Probably we will see 21

that in some particular season 22

chairs are sold more in some season chairs are sold less 23

once you have done this 24

You have learnt 25

the datetime function successfully